Re: standard schemas for addresses, others?

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

Responses

Browse pgsql-general by date

  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)