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

From Dennis Gearon
Subject Re: standard schemas for addresses, others?
Date
Msg-id D42RQE9ICTRA7XWHEE0NTOPOUT9GA.3e3086d8@cal-lab
Whole thread Raw
In response to Re: standard schemas for addresses, others?  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-general
Oh,
    but I WANT customers everywhere, and ....

    my money for nothing and my chicks for free of course! Just trying to plan ahead for
when I can hire everyone else on this list!

    I guess I've been spending too much time next to a monitor :-)

1/23/2003 3:30:49 PM, Peter Eisentraut <peter_e@gmx.net> wrote:

>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: Peter Eisentraut
Date:
Subject: Re: standard schemas for addresses, others?
Next
From: "Luke Pascoe"
Date:
Subject: Inherited tables and NOT NULL (pg 7.2.1)