On Wed, Jul 20, 2005 at 11:28:23AM +0200, Josef Springer wrote:
> i want to automate the startup of my database. So i have to create first
> an user and a database, second the schema, all with psql. But how can i
> create a database with psql if no database exist ?
When you first install Postgre
Hi,
1. connect template1 database with your user.
2. create database YOURDB
3. "\c YOURDB" will connect to new database
4. create table etc.
linimi
On 7/20/05, Josef Springer <[EMAIL PROTECTED]> wrote:
> Hi,
>
> i want to automate the startup of my database. So i have to create first
> an user
Hi,
i want to automate the startup of my database. So i have to create first
an user and a database, second the schema, all with psql. But how can i
create a database with psql if no database exist ? Executing psql, i
must define the options for a database and an user with password.
Best Reg
Tom Lane wrote:
>
> Richard Francis Duggan <[EMAIL PROTECTED]> writes:
> > I am trying to create a database and use the following command:
> > 'createdb '
> > However I get the following error:
> > ERROR: CREATE DATABASE: could not initialize database directory
> > createdb: database creation fa
Richard Francis Duggan <[EMAIL PROTECTED]> writes:
> I am trying to create a database and use the following command:
> 'createdb '
> However I get the following error:
> ERROR: CREATE DATABASE: could not initialize database directory
> createdb: database creation failed
Hm. That
