From: | "John R(dot) Sowden" <jsowden(at)americansentry(dot)net> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | external table |
Date: | 2014-07-04 09:33:31 |
Message-ID: | 53B674EB.5080404@americansentry.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
I am currently writing my own database apps in foxpro/dos (since 1980).
pg seems to be a good way to move on, but I see a couple of problems.
All of the application programs seem to be c based. Learning c for
business apps is a problem.
Currently I use a lookup database for many kinds of applications that I
create for my company. It seems that the sql database arrangement is to
have 1 database with multiple related tables inside. I do not want to
have to keep current multiple look-up tables (cities, counties, police
depts, their phone numbers, etc.) in separate databases. Can I use, say
a database with billing tables (transacions, etc.) and refer to an
external lookup table? I might store a "G" in the city field, which
would refer to "San Francisco", etc.
tia,
John
From | Date | Subject | |
---|---|---|---|
Next Message | Albe Laurenz | 2014-07-04 09:47:53 | Re: external table |
Previous Message | Ravi Kiran | 2014-07-02 16:36:10 | tool to be used |