Re: createdb

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(at)telkomsa(dot)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
>