diff options
| author | Peter Eisentraut <peter_e@gmx.net> | 2012-02-09 20:15:48 +0200 |
|---|---|---|
| committer | Peter Eisentraut <peter_e@gmx.net> | 2012-02-09 20:20:15 +0200 |
| commit | 169c8a911260bd5a8b6910c458afa57a1ae29627 (patch) | |
| tree | bfd5b4ee2f9ab327fa19337492b36794b3f31d25 /doc/src | |
| parent | dd7c84185c160bb0d95bd265182f24f1f6c21924 (diff) | |
| download | postgresql-169c8a911260bd5a8b6910c458afa57a1ae29627.tar.gz postgresql-169c8a911260bd5a8b6910c458afa57a1ae29627.zip | |
psql: Support zero byte field and record separators
Add new psql settings and command-line options to support setting the
field and record separators for unaligned output to a zero byte, for
easier interfacing with other shell tools.
reviewed by Abhijit Menon-Sen
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/ref/psql-ref.sgml | 41 |
1 files changed, 41 insertions, 0 deletions
diff --git a/doc/src/sgml/ref/psql-ref.sgml b/doc/src/sgml/ref/psql-ref.sgml index a9b1ed2699d..55aa5f2ac1d 100644 --- a/doc/src/sgml/ref/psql-ref.sgml +++ b/doc/src/sgml/ref/psql-ref.sgml @@ -482,6 +482,27 @@ PostgreSQL documentation </listitem> </varlistentry> + <varlistentry> + <term><option>-z</option></term> + <term><option>--field-separator-zero</option></term> + <listitem> + <para> + Set the field separator for unaligned output to a zero byte. + </para> + </listitem> + </varlistentry> + + <varlistentry> + <term><option>-0</option></term> + <term><option>--record-separator-zero</option></term> + <listitem> + <para> + Set the record separator for unaligned output to a zero byte. This is + useful for interfacing, for example, with <literal>xargs -0</literal>. + </para> + </listitem> + </varlistentry> + <varlistentry> <term><option>-1</option></term> <term><option>--single-transaction</option></term> @@ -1909,6 +1930,16 @@ lo_import 152801 </varlistentry> <varlistentry> + <term><literal>fieldsep_zero</literal></term> + <listitem> + <para> + Sets the field separator to use in unaligned output format to a zero + byte. + </para> + </listitem> + </varlistentry> + + <varlistentry> <term><literal>footer</literal></term> <listitem> <para> @@ -2078,6 +2109,16 @@ lo_import 152801 </varlistentry> <varlistentry> + <term><literal>recordsep_zero</literal></term> + <listitem> + <para> + Sets the record separator to use in unaligned output format to a zero + byte. + </para> + </listitem> + </varlistentry> + + <varlistentry> <term><literal>tableattr</literal> (or <literal>T</literal>)</term> <listitem> <para> |