On Sun, 6 Nov 2005 18:06:11 -0700, Assad Jarrahian <jarraa@xxxxxxxxx> wrote: > Hi, > I am writing a .sql file to create a database, connect to it and create > tables etc. (basic db setup). > But I cannot figure out how to connect to the server (what statement) in a > .sql file. > > any help would be appreciated. What's going to play the script? If psql, then check out the \c command. klint. +---------------------------------------+-----------------+ : Klint Gore : "Non rhyming : : EMail : kg@xxxxxxxxxxxxxx : slang - the : : Snail : A.B.R.I. : possibilities : : Mail University of New England : are useless" : : Armidale NSW 2351 Australia : L.J.J. : : Fax : +61 2 6772 5376 : : +---------------------------------------+-----------------+ ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings