Re: createdb
| От | Shoaib Mir |
|---|---|
| Тема | Re: createdb |
| Дата | |
| Msg-id | bf54be870607260052me9504e1w2ce69179937309b7@mail.gmail.com обсуждение исходный текст |
| Ответ на | createdb (Alex du Plessis <alexdup01@telkomsa.net>) |
| Список | 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)
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 по дате отправления: