Re: how do you set foriegn keys in pgaccess?

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 ` <norman1nz@hotmail.com> 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 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
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 8: explain analyze is your friend
>




__________________________________
Discover Yahoo!
Find restaurants, movies, travel and more fun for the weekend. Check it out!
http://discover.yahoo.com/weekend.html