Skip site navigation (1) Skip section navigation (2)


From: Ralf Boeckenholt <webmaster(at)chopper(dot)de>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Problem
Date: 2000-09-05 22:46:08
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-bugs

In the final part of this message you found the help message of the
pg_dump edition. There is no option to choose "insert proper sql
strings" and 
there is no point on which I can choose a file the program can put in
output. What can I do to put it in later postgress editions ?

thanks Ralf

  pg_dump [options] dbname

  -a, --data-only          dump out only the data, not the schema
  -c, --clean              clean (drop) schema prior to create
  -d, --inserts            dump data as INSERT, rather than COPY,
  -D, --attribute-inserts  dump data as INSERT commands with attribute
  -h, --host <hostname>    server host name
  -i, --ignore-version     proceed when database version != pg_dump
  -n, --no-quotes          suppress most quotes around identifiers
  -N, --quotes             enable most quotes around identifiers
  -o, --oids               dump object ids (oids)
  -p, --port <port>        server port number
  -s, --schema-only        dump out only the schema, no data
  -t, --table <table>      dump for this table only
  -u, --password           use password authentication
  -v, --verbose            verbose
  -x, --no-acl             do not dump ACL's (grant/revoke)

If no database name is not supplied, then the PGDATABASE environment
variable value is used.

Report bugs to <pgsql-bugs(at)postgresql(dot)org>.
postgres(at)linux:~ >

Bis dann Ralf
FAX NUMMER : 069-79123-8384                     Handy : 0174-6432399

Harley Davidson history page (ger) :
In the day we sweat it out in the streets of a runaway american dream
At night we ride through mansions of glory in suicide machines
                                    [Bruce Springsteen : Born to run]

pgsql-bugs by date

Next:From: pgsql-bugsDate: 2000-09-06 04:31:19
Subject: /usr/include/pgsql/os.h does not exist
Previous:From: pgsql-bugsDate: 2000-09-05 16:09:15
Subject: Access 97 and PSQL ODBC Update

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group