Filewatcher File Search File Search
Content Search
» » » » » » postgresql-7.1.3-5.72.i386.rpm » Content »
pkg://postgresql-7.1.3-5.72.i386.rpm:1178664/usr/share/man/man1/  info  HEADER  downloads

postgresql - PostgreSQL client programs and libraries.…  more info»


CREATEDB(1)        PostgreSQL Client Applications        CREATEDB(1)

       createdb - Create a new Postgres database

       createdb [ options... ] [ dbname ] [ description ]

       -h, --host host
              Specifies  the  hostname  of  the machine on which the
              postmaster is running. If host begins with a slash, it
              is used as the directory for the Unix domain socket.

       -p, --port port
              Specifies  the  Internet TCP/IP port or the local Unix
              domain socket file extension on which  the  postmaster
              is listening for connections.

       -U, --username username
              Username to connect as.

       -W, --password
              Force password prompt.

       -e, --echo
              Echo  the queries that createdb generates and sends to
              the backend.

       -q, --quiet
              Do not display a response.

       -D, --location datadir
              Specifies the alternative location for  the  database.
              See also initlocation(1).

       -T, --template template
              Specifies  the  template  database from which to build
              this database.

       -E, --encoding encoding
              Specifies the character encoding scheme to be used  in
              this database.

       dbname Specifies  the name of the database to be created. The
              name must be unique among all  Postgres  databases  in
              this  installation.   The default is to create a data‐
              base with the same name as the current system user.

              This optionally specifies a comment to  be  associated
              with the newly created database.

       The options -h, -p, -U, -W, and -e are passed on literally to
       psql(1).  The options -D,  -T,  and  -E  are  converted  into
       options  for the underlying SQL command CREATE DATABASE [cre‐
       ate_database(l)]; see there for more information about them.

              The database was successfully created.

       createdb: Database creation failed.
              (Says it all.)

       createdb: Comment creation failed. (Database was created.)
              The comment/description for the database could not  be
              created.   The  database itself will have been created
              already. You can use the SQL command COMMENT ON  DATA‐
              BASE to create the comment later on.

       If  there  is  an  error condition, the backend error message
       will be displayed.  See create_database(l)  and  psql(1)  for

       createdb  creates  a new Postgres database. The user who exe‐
       cutes this command becomes the database owner.

       createdb is a shell script wrapper  around  the  SQL  command
       CREATE  DATABASE [create_database(l)] via the Postgres inter‐
       active terminal psql(1). Thus, there is nothing special about
       creating databases via this or other methods. This means that
       the psql program must be found by the script and that a data‐
       base  server  must be running at the targeted port. Also, any
       default settings and environment variables available to  psql
       and the libpq front-end library will apply.

       To  create  the  database  demo  using  the  default database

       $ createdb demo

       The response is the same as you would have gotten  from  run‐
       ning the CREATE DATABASE SQL command.

       To  create  the  database  demo  using the postmaster on host
       eden, port 5000, using the LATIN1 encoding scheme with a look
       at the underlying query:

       $ createdb -p 5000 -h eden -E LATIN1 -e demo

Application                  2000-11-11                  CREATEDB(1)
Results 1 - 1 of 1
Help - FTP Sites List - Software Dir.
Search over 15 billion files
© 1997-2017