how do you set foriegn keys in pgaccess?

From: "jeremy `" <norman1nz(at)hotmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: how do you set foriegn keys in pgaccess?
Date: 2005-06-09 05:22:09
Message-ID: BAY9-F99B63FCE6D51DDEBE1AEBFBFC0@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 query:
How do you export the database tables and relationships etc? I found a
pg_dump command in help and I am guessing this I what i need but where do I
enter this command in pgaccess?

Also how do you input existing SQL script into postgres?

Thanks for any help.
Jeremy

_________________________________________________________________
Become a fitness fanatic @ http://xtramsn.co.nz/health

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2005-06-09 07:52:40 Strange transaction-id behaviour? (was Re: Two updates problem)
Previous Message Neil Conway 2005-06-09 04:34:15 Re: So maybe SQLERRM? Sb knows how to check it?