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.htmlThanks,
--
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