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@xxxxxxxxxxx> 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 ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly
