Re: Database design : international postal address - Mailing list pgsql-general

From Pavel Stehule
Subject Re: Database design : international postal address
Date
Msg-id 162867790707182301w7a35c369h10b5c2d4e2806155@mail.gmail.com
Whole thread Raw
In response to Database design : international postal address  (Bruno Lavoie <bruno.lavoie@gmail.com>)
List pgsql-general
Hello

http://www.bitboost.com/ref/international-address-formats.html
http://www.census.gov/geo/www/standards/scdd/AddressStandardV2_April%2017_2003.htm

Rock solid solution will be propably too heavy. Propably you can find
some more national specific sources.

Regards
Pavel



2007/7/19, Bruno Lavoie <bruno.lavoie@gmail.com>:
> Hello guys,
>
> I am currently designing a database which has several tables (e.g. a
> Customer table) which include address information such as street
> address, city, state, country code, and zip code, and phone number
> information in
> each record.  We need to make the schema for these tables sufficient to
> accomodate entries for international customers.
>
> I figured someone else reading this may have developed a database with
> similar international concerns and have some suggestions that would help
> us avoid any pitfalls as we move forward.
> Is a standard for international addresses exists in the case of database
> design? in representation?
>
> I want to be rock solid....
>
>
> Any suggestions/help is appreciated! Thanks!!
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>

pgsql-general by date:

Previous
From: "Mikko Partio"
Date:
Subject: Re: Unexpected crash
Next
From: "Pat Maddox"
Date:
Subject: Trying to tune postgres, how is this config?