Don't forget to cc: the list.
jeremy ` wrote:
yea sory I an using pgadmin3, and thats the prog that I'm not sure how
to set foriegn keys with.
OK - to make a foreign key where bar.foo_ref references foo.foo_id you
should do the following:
1. Select table bar then constraints
2. Right-click
Hi, Jeremy,
Have you tried PGadminIII? It's much easier to use.
To input a script, you can use psql
psql -h HOSTNAME -d DANAME -f FILENAME -U USERNAME
Changyu
--- jeremy ` [EMAIL PROTECTED] wrote:
I am a bit of a newbie to postgres, but I managed to
install 8.0.4 on my
windows box and it
jeremy ` wrote:
I am a bit of a newbie to postgres, but I managed to install 8.0.4 on my
windows box and it mostly appears to be working fine;
I can set a primary key constraint, but when i try to set the foreign
key it requires a 'reference' - but there is nothing there to chose from.
I also
I am a bit of a newbie to postgres, but I managed to install 8.0.4 on my
windows box and it mostly appears to be working fine;
I can set a primary key constraint, but when i try to set the foreign key it
requires a 'reference' - but there is nothing there to chose from.
I also have another