for the primary key being a 'natural key' vs. a 'synthetic' one,
that's a huge debate akin to emacs vs. vi. Depending on your situation, there's
nothing wrong with using natural keys. It is discussed at length and
in some cases encouraged here::
http://database-program
es numeric id columns to link tables, as well as many constraints
to ensure valid input and about a hundred other tables. In the example I used
names as keys rather than numeric ID's to try and make it a little easier to
follow my intent. Perhaps this had the opposite effect.
-Modulok-
--
S
classes and just having a single 'genes' table which has a blob column but I
hesitate to do that because I want to be able to do queries on aggregate allele
stats. Things like "how many persons have pupil type 1?", etc.
It's late and I've probably over complicated it. Any
ou can type :list_databases to get the same effect as \l
>
> -Kevin
Thank you. This is perfect!
-Modulok-
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
such aliases? I'm using 9.2.3 if that matters. I
didn't see anything in the man page. If not is there another command line
client interface?
Cheers!
-Modulok-
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.post
