| From: | Heikki Linnakangas <heikki(at)enterprisedb(dot)com> |
|---|---|
| To: | sharath kumar <k(dot)sharat(at)gmail(dot)com> |
| Cc: | Andrew Dunstan <andrew(at)dunslane(dot)net>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: schema creation during initdb |
| Date: | 2007-04-18 10:07:12 |
| Message-ID: | 4625EDD0.4000300@enterprisedb.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
sharath kumar wrote:
> Sorry i have put the question wrongly. I wanted to ask if we can create a
> schema during createdb time so that i have to hide the following from the
> user.
> psql -c 'create schema foo' mytemplate
> psql -c 'create table foo.bar ...' mytemplate
> Whenever a user runs createdb command, the above schema and table should be
> created automatically.
You should create a template database with the schema and the tables you
want. See chapter "19.3. Template Databases" in the user manual:
http://www.postgresql.org/docs/8.2/interactive/manage-ag-templatedbs.html
--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | NikhilS | 2007-04-18 10:26:02 | Re: schema creation during initdb |
| Previous Message | sharath kumar | 2007-04-18 09:19:19 | Re: schema creation during initdb |