Обсуждение: Creating a database with psql

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 Regards,
Josef Springer

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 <Josef.Springer@joops.com> wrote:
> 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 Regards,
> Josef Springer
>
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
>        subscribe-nomail command to majordomo@postgresql.org so that your
>        message can get through to the mailing list cleanly
>

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 PostgreSQL, you run initdb to initialize a
cluster.  This creates a few default databases and a database
superuser.  Then you start the backend and make connections to it
using psql or some other client.  See the "Server Administration"
part of the documentation for more information:

http://www.postgresql.org/docs/8.0/static/admin.html

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/