PostgresQL Address Type and Standardizer
Namespaces
udt
Note
tiger
will be created by thepostgis_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