From: | Oliver Vecernik <vecernik(at)aon(dot)at> |
---|---|
To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: standard schemas for addresses, others? |
Date: | 2003-01-24 02:25:50 |
Message-ID: | 3E30A42E.4020209@aon.at |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Dennis Gearon schrieb:
>> Are there any sites with 'standard schemas' for certain, repetitive
>> database needs? For
>> example, addresses and their components. Does anyone have a schema for
>> addresses that will
>> work for the USA *AND* internation addresses?
>
>
There is a great source of information on:
http://www.upu.int/post_code/en/addressing_formats_guide.shtml
But it also shows how difficult the actual situation is. Even if you're
sending to the same addressee the format is depending on the origin from
where it is sent. Refer to:
http://www.upu.int/post_code/en/formatting_international_address_en.pdf
If you're interested I can post the structure of Mozilla address book.
It seems to be sufficent for my needs.
HTH
Oliver
--
VECERNIK Datenerfassungssysteme
A-2560 Hernstein, Hofkogelgasse 17
Tel.: +43 2633 47530, Fax: DW 50
http://members.aon.at/vecernik
From | Date | Subject | |
---|---|---|---|
Next Message | codeWarrior | 2003-01-24 02:41:53 | Re: pg_dump automatic |
Previous Message | Magnus Naeslund(f) | 2003-01-24 02:13:32 | Re: Inherited tables and NOT NULL (pg 7.2.1) |