sharath kumar wrote:
How can I create a schema during initdb time?
For example pg_catalog, pg_toast, information_schema are created during initdb time. Likewise I want to create my own schema at initdb time. How can i do it? Also how to create a table into this schema at that time itself?

This question really does not belong on -hackers, which is about postgres development, not usage. Next time use pgsql-general.

You have misunderstood the purpose of initdb, which is to prepare a location for running a postmaster against.

After initdb has run there are no user databases yet created (unless you count the postgres database).

So you would need to do something like this:

 initdb ...
 pg_ctl start ...
 createdb mytemplate
 psql -c 'create schema foo' mytemplate
 psql -c 'create table ...' mytemplate

After that you can do this:

 createdb --template mytemplate newdb

and the newdb will have your schema and table.



---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at


Reply via email to