From: | Andrew Dunstan <andrew(at)dunslane(dot)net> |
---|---|
To: | sharath kumar <k(dot)sharat(at)gmail(dot)com> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: schema creation during initdb |
Date: | 2007-04-17 20:18:42 |
Message-ID: | 46252BA2.6040406@dunslane.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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 foo.bar ...' mytemplate
After that you can do this:
createdb --template mytemplate newdb
and the newdb will have your schema and table.
HTH
andrew
From | Date | Subject | |
---|---|---|---|
Next Message | Heikki Linnakangas | 2007-04-17 20:23:46 | Re: Unhelpful debug tools on OS X :-( |
Previous Message | sharath kumar | 2007-04-17 19:59:33 | schema creation during initdb |