Re: standard schemas for addresses, others? - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: standard schemas for addresses, others?
Date
Msg-id Pine.LNX.4.44.0301231943540.789-100000@localhost.localdomain
Whole thread Raw
In response to standard schemas for addresses, others?  (Dennis Gearon <gearond@cvc.net>)
Responses Re: standard schemas for addresses, others?
List pgsql-general
Dennis Gearon writes:

> 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?

No chance.  You need to cut a compromise between structure and
flexibility.  If you just want to save, say, shipping addresses, then make
them free text -- person name, address information, country.  (Possibly
divide the address information into street'ish and city'ish, but that's
already pushing it.)  If you need the addresses to be structured so you
can do data analysis then you need to define your actual needs.  Probably
you don't have customers *everywhere*.

--
Peter Eisentraut   peter_e@gmx.net


pgsql-general by date:

Previous
From: Dennis Gearon
Date:
Subject: Re: ORDER BY 'criteria'
Next
From: Dennis Gearon
Date:
Subject: Re: standard schemas for addresses, others?