Skip to main content
A US postal address arrives as one line of freeform text, and almost every use of it needs the parts: the house number, the street, the unit, the city, the state, the ZIP. vsql_address_standardizer splits that line apart in SQL and normalizes what it finds, so north becomes N and new york becomes NY. It was inspired by PostgreSQL’s address_standardizer contrib module.
A third party writes and maintains this extension. VillageSQL does not build, test, or ship it, and the description below follows the maintainer’s own documentation. Read that documentation before you rely on it.

​
Install

Build it from the repository against a VillageSQL build tree (VillageSQL_BUILD_DIR), copy the .veb file into the server’s veb_dir, then install it:

​
What it adds

It handles US addresses only.

​
See also