| 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: | Whole Thread | Raw Message | 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
| 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? |