Re: Connect to a database in a .sql file

Hi,
Lets say the script is called myDBSetup.sql

And the script contains:

//CREATE DATABASE section
//CREATE USERS SECTION
//COnnect to db
//CREATE TABLES, FUNCTIONS etc.

this script will be called from psql. The user will log connect to template1
and then run my script. What I really need is after the CREATE DB, I need to
switch from template1 to the database name (so the CREATE tables etc will
correspond to the right db). This has to be automated and done within the
script.

\c does not work in .sql script run in psql.

Any suggestions would be helpful. Thanks.
-assad

On 11/6/05, Klint Gore <kg(at)kgb(dot)une(dot)edu(dot)au > wrote:
>
> On Sun, 6 Nov 2005 18:06:11 -0700, Assad Jarrahian <jarraa(at)gmail(dot)com>
> 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(at)kgb(dot)une(dot)edu(dot)au : 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 : :
> +---------------------------------------+-----------------+
>