Re: createdb - Mailing list pgsql-novice

From Shoaib Mir
Subject Re: createdb
Date
Msg-id bf54be870607260052me9504e1w2ce69179937309b7@mail.gmail.com
Whole thread Raw
In response to createdb  (Alex du Plessis <alexdup01@telkomsa.net>)
List pgsql-novice
Set the envoirnment variables like PGHOST, PGPORT, PGUSER, etc and for the password info you can use either PGPASSFILE or PGPASSWORD (not a secure way to do, PGPASSFILE is a preffered approach). After you have all these variables set, you then do not have to supply all data and just call the createdb and pass it the database name that you want to create.

Help on these envoirnment variables can be found at --> http://www.postgresql.org/docs/8.1/interactive/libpq-envars.html

Thanks,
--
Shoaib Mir
EnterpriseDB ( www.enterprisedb.com)


On 7/26/06, Alex du Plessis < alexdup01@telkomsa.net> wrote:
Hello List,

Is there an automated way to use createdb i.e. supplying all input data
programatically (including user password)?

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
       choose an index scan if your joining column's datatypes do not
       match




pgsql-novice by date:

Previous
From: Alex du Plessis
Date:
Subject: createdb
Next
From: "roy simkes"
Date:
Subject: Limiting character count