<!--

$PostgreSQL: pgsql/doc/src/sgml/ref/pg_dump.sgml,v 1.102 2008/04/13 03:49:21 tgl Exp $

$PostgreSQL: pgsql/doc/src/sgml/ref/pg_dump.sgml,v 1.103 2008/07/20 18:43:30 tgl Exp $

PostgreSQL documentation

-->

</listitem>

</varlistentry>

<varlistentry>

<term><option>--no-tablespaces</option></term>

<listitem>

<para>

Do not output commands to select tablespaces.

With this option, all objects will be created in whichever

tablespace is the default during restore.

</para>

<para>

This option is only meaningful for the plain-text format. For

the archive formats, you can specify the option when you

call <command>pg_restore</command>.

</para>

</listitem>

</varlistentry>

<varlistentry>

<term><option>-s</option></term>

<term><option>--schema-only</option></term>

</listitem>

</varlistentry>

<varlistentry>

<term><option>-Z <replaceable class="parameter">0..9</replaceable></option></term>

<term><option>--compress=<replaceable class="parameter">0..9</replaceable></option></term>

<listitem>

<para>

Specify the compression level to use in archive formats that

support compression. (Currently only the custom archive

format supports compression.)

</para>

</listitem>

</varlistentry>

<varlistentry>

<term><option>--disable-dollar-quoting</></term>

<listitem>

<para>

This option disables the use of dollar quoting for function bodies,

and forces them to be quoted using SQL standard string syntax.

</para>

</listitem>

</varlistentry>

</listitem>

</varlistentry>

<varlistentry>

<term><option>--disable-triggers</></term>

</listitem>

</varlistentry>

<varlistentry>

<term><option>--lock-wait-timeout=<replaceable class="parameter">timeout</replaceable></option></term>

<listitem>

<para>

Do not wait forever to acquire shared table locks at the beginning of

the dump. Instead fail if unable to lock a table within the specified

<replaceable class="parameter">timeout</>. The timeout may be

specified in any of the formats accepted by <command>SET

statement_timeout</>. (Allowed values vary depending on the server

version you are dumping from, but an integer number of milliseconds

is accepted by all versions since 7.3. This option is ignored when

dumping from a pre-7.3 server.)

</para>

</listitem>

</varlistentry>

<varlistentry>

<term><option>--no-tablespaces</option></term>

<listitem>

<para>

Do not output commands to select tablespaces.

With this option, all objects will be created in whichever

tablespace is the default during restore.

</para>

<para>

This option is only meaningful for the plain-text format. For

the archive formats, you can specify the option when you

call <command>pg_restore</command>.

</para>

</listitem>

</varlistentry>

<varlistentry>

<term><option>--use-set-session-authorization</></term>

<listitem>

</para>

</listitem>

</varlistentry>

<varlistentry>

<term><option>-Z <replaceable class="parameter">0..9</replaceable></option></term>

<term><option>--compress=<replaceable class="parameter">0..9</replaceable></option></term>

<listitem>

<para>

Specify the compression level to use in archive formats that

support compression. (Currently only the custom archive

format supports compression.)

</para>

</listitem>

</varlistentry>

</variablelist>

</para>

<listitem>

<para>

Force <application>pg_dump</application> to prompt for a

password before connecting to a database.

password before connecting to a database.

</para>

<para>

boolschemaOnly;

booldataOnly;

boolaclsSkip;

constchar*lockWaitTimeout;

staticconstchar*username_subquery;

{"disable-dollar-quoting",no_argument,&disable_dollar_quoting,1},

{"disable-triggers",no_argument,&disable_triggers,1},

{"lock-wait-timeout",required_argument,NULL,2},

{"no-tablespaces",no_argument,&outputNoTablespaces,1},

{"use-set-session-authorization",no_argument,&use_setsessauth,1},

strcpy(g_opaque_type,"opaque");

dataOnly=schemaOnly=dumpInserts=attrNames= false;

lockWaitTimeout=NULL;

progname=get_progname(argv[0]);

break;

case2:

lockWaitTimeout=optarg;

break;

default:

fprintf(stderr,_("Try \"%s --help\" for more information.\n"),progname);

exit(1);

printf(_(" %s [OPTION]... [DBNAME]\n"),progname);

printf(_("\nGeneral options:\n"));

printf(_(" -f, --file=FILENAME output file name\n"));

printf(_(" -F, --format=c|t|p output file format (custom, tar, plain text)\n"));

printf(_(" -v, --verbose verbose mode\n"));

printf(_(" -Z, --compress=0-9 compression level for compressed formats\n"));

printf(_(" --help show this help, then exit\n"));

printf(_(" --version output version information, then exit\n"));

printf(_(" -f, --file=FILENAME output file name\n"));

printf(_(" -F, --format=c|t|p output file format (custom, tar, plain text)\n"));

printf(_(" -v, --verbose verbose mode\n"));

printf(_(" -Z, --compress=0-9 compression level for compressed formats\n"));

printf(_(" --lock-wait-timeout=TIMEOUT fail after waiting TIMEOUT for a table lock\n"));

printf(_(" --help show this help, then exit\n"));

printf(_(" --version output version information, then exit\n"));

printf(_("\nOptions controlling the output content:\n"));

printf(_(" -a, --data-only dump only the data, not the schema\n"));

intntups;

inti;

PQExpBufferquery=createPQExpBuffer();

PQExpBufferdelqry=createPQExpBuffer();

PQExpBufferlockquery=createPQExpBuffer();

TableInfo*tblinfo;

inti_reltableoid;

inti_reloid;

i_reltablespace=PQfnumber(res,"reltablespace");

i_reloptions=PQfnumber(res,"reloptions");

if (lockWaitTimeout&&g_fout->remoteVersion >=70300)

{

resetPQExpBuffer(query);

appendPQExpBuffer(query,"SET statement_timeout = ");

appendStringLiteralConn(query,lockWaitTimeout,g_conn);

do_sql_command(g_conn,query->data);

}

for (i=0;i<ntups;i++)

{

tblinfo[i].dobj.objType=DO_TABLE;

if (tblinfo[i].dobj.dump&&tblinfo[i].relkind==RELKIND_RELATION)

{

resetPQExpBuffer(lockquery);

appendPQExpBuffer(lockquery,

resetPQExpBuffer(query);

appendPQExpBuffer(query,

"LOCK TABLE %s IN ACCESS SHARE MODE",

fmtQualifiedId(tblinfo[i].dobj.namespace->dobj.name,

tblinfo[i].dobj.name));

do_sql_command(g_conn,lockquery->data);

do_sql_command(g_conn,query->data);

}

tblinfo[i].dobj.name);

}

if (lockWaitTimeout&&g_fout->remoteVersion >=70300)

{

do_sql_command(g_conn,"SET statement_timeout = 0");

}

PQclear(res);

}

destroyPQExpBuffer(query);

destroyPQExpBuffer(delqry);

destroyPQExpBuffer(lockquery);

returntblinfo;

}