@cran/psql.addr

PostgresQL Address Type and Standardizer

Namespaces

• udt

Note tiger will be created by the postgis_tiger_geocoder dependency.

Dependencies

• postgis_tiger_geocoder
• postgis_topology
• postgis

Usage

\i node_modules/@cran/psql.addr/out/migrate.sql
\i node_modules/@cran/psql.addr/out/rollback.sql

Type

udt.addr

street	unit	city	state	zipcode
text	text	text	text	text

Cast

text to addr

select '9000 East Roo St Suite 999, Springfield CO 81073'::text::udt.addr;

                       addr
--------------------------------------------------
 ("9000 E ROO ST","STE 999",SPRINGFIELD,CO,81073)

addr to text

select ('9000 E ROO ST','STE 999','SPRINGFIELD','CO','81073')::udt.addr::text;

                      row
-----------------------------------------------
 9000 E ROO ST STE 999, SPRINGFIELD, CO, 81073

text to addr to text

select '9000 East Roo St Suite 999, Springfield CO 81073'::text::udt.addr::text;

                     text
-----------------------------------------------
 9000 E ROO ST STE 999, SPRINGFIELD, CO, 81073