aboutsummaryrefslogtreecommitdiffstats
path: root/src/_pgsql_utils
diff options
context:
space:
mode:
authorJ Smith <dark.panda@gmail.com>2012-09-10 16:40:33 -0400
committerJ Smith <dark.panda@gmail.com>2012-09-11 14:29:00 -0400
commit1b2dabcd2eed1cfc729812721721457cf440d4df (patch)
treecf5d0ee90e0b98fe723c197d352f069c0ab3bff5 /src/_pgsql_utils
parentAdd the -T/--exclude-table option for pg_dump. (diff)
downloadzsh-completions-1b2dabcd2eed1cfc729812721721457cf440d4df.tar
zsh-completions-1b2dabcd2eed1cfc729812721721457cf440d4df.tar.gz
zsh-completions-1b2dabcd2eed1cfc729812721721457cf440d4df.tar.bz2
zsh-completions-1b2dabcd2eed1cfc729812721721457cf440d4df.tar.lz
zsh-completions-1b2dabcd2eed1cfc729812721721457cf440d4df.tar.xz
zsh-completions-1b2dabcd2eed1cfc729812721721457cf440d4df.tar.zst
zsh-completions-1b2dabcd2eed1cfc729812721721457cf440d4df.zip
Add a bunch of additional options for pg_dump.
Diffstat (limited to 'src/_pgsql_utils')
-rw-r--r--src/_pgsql_utils11
1 files changed, 10 insertions, 1 deletions
diff --git a/src/_pgsql_utils b/src/_pgsql_utils
index 1095949..b7bddd4 100644
--- a/src/_pgsql_utils
+++ b/src/_pgsql_utils
@@ -202,7 +202,16 @@ _pg_dump () {
{-x,--no-{acl,privileges}}'[dont dump ACLs]' \
-X+':option:_values "option" use-set-session-authorization disable-triggers' \
{-Z+,--compress=}':compression level:_values "level" 9 8 7 6 5 4 3 2 1 0' \
- ':PostgreSQL database:_pgsql_databases'
+ ':PostgreSQL database:_pgsql_databases' \
+ --section=':dump named section:_values "section" pre-data data post-data' \
+ --disable-dollpgar-quoting'[disable dollar quoting, use SQL standard quoting]' \
+ --disable-triggers'[disable triggers during data-only restore]' \
+ --no-security-labels'[do not dump security label assignments]' \
+ --no-tablespaces'[do not dump tablespace assignments]' \
+ --no-unlogged-table-data'[do not dump unlogged table data]' \
+ --quote-all-identifiers'[quote all identifiers, even if not key words]' \
+ --serializable-deferrable'[wait until the dump can run without anomalies]' \
+ --use-set-session-authorization'[use SET SESSION AUTHORIZATION commands instead of ALTER OWNER]'
}
_createdb () {