From: | "Barnes" <aardvark(at)ibm(dot)net> |
---|---|
To: | "'sheila bel'" <sheilabel(at)hotmail(dot)com>, <pgsql-general(at)postgresql(dot)org> |
Subject: | RE: [GENERAL] using ID as a key |
Date: | 2000-02-04 17:22:57 |
Message-ID: | 000301bf6f34$7b32e9e0$0a64a8c0@fries |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Take a look at Bruce's book at http://www.postgresql.org/docs/awbook.html
He explains oid's and sequences extremely well, and that might be what you
are looking for.
-----Original Message-----
From: owner-pgsql-general(at)postgreSQL(dot)org
[mailto:owner-pgsql-general(at)postgreSQL(dot)org]On Behalf Of sheila bel
Sent: Friday, February 04, 2000 11:41 AM
To: pgsql-general(at)postgreSQL(dot)org
Subject: [GENERAL] using ID as a key
Hi,
I'm new to data base design so please bare with me if my
question is so basic..
I'm designing a database, two of the tables are EMPLOYEES and
AGENCIES. I need an ID for each of them. I would also need to
have the agencyID in the EMPLOYEES table so that I can identify
which agency they belong to something like a foreign key. I know
postgreSQL does not support it so how do I implement this ?
What kind of data type should I use for the ID ? In general I
do not know how to implement IDs and use them as keys.
I've read the user manual and a bit of the programmer's
manual several times but haven't found anything that will
apply to this situation.
Please Help. Thank You.
-Sheila
************
From | Date | Subject | |
---|---|---|---|
Next Message | Marc Tardif | 2000-02-04 17:43:59 | Re: [GENERAL] using ID as a key |
Previous Message | George | 2000-02-04 17:14:12 | (no subject) |