aboutsummaryrefslogtreecommitdiffstats
path: root/src/_pgsql_utils
diff options
context:
space:
mode:
authorMartin Tournoij <martin@arp242.net>2020-06-03 11:38:52 +0800
committerMartin Tournoij <martin@arp242.net>2020-06-03 11:40:37 +0800
commitf37143161905ca23bc5e2737dafae50b6c90e4ad (patch)
tree447835f551925dbdaffbd4eb48f7b8892fb361bd /src/_pgsql_utils
parentMerge pull request #747 from okuramasafumi/nanoc-completion (diff)
downloadzsh-completions-f37143161905ca23bc5e2737dafae50b6c90e4ad.tar
zsh-completions-f37143161905ca23bc5e2737dafae50b6c90e4ad.tar.gz
zsh-completions-f37143161905ca23bc5e2737dafae50b6c90e4ad.tar.bz2
zsh-completions-f37143161905ca23bc5e2737dafae50b6c90e4ad.tar.lz
zsh-completions-f37143161905ca23bc5e2737dafae50b6c90e4ad.tar.xz
zsh-completions-f37143161905ca23bc5e2737dafae50b6c90e4ad.tar.zst
zsh-completions-f37143161905ca23bc5e2737dafae50b6c90e4ad.zip
pgsql: add -X to psql commands to prevent loading ~/.psqlrc
The ~/.psqlrc may alter the output. In particular, I have '\timing on' in there to add timings. This is useful when using psql, but not when relying on it in scripts. For example: psql -Aqt -c "select n.nspname \ from pg_catalog.pg_namespace n \ where n.nspname "'!~'" '^pg_' \ and n.nspname <> 'information_schema' \ order by 1;" postgres 2>/dev/null Gives the output: public Time: 1.882 ms Whereas with -X it gives the standard output: public
Diffstat (limited to 'src/_pgsql_utils')
-rw-r--r--src/_pgsql_utils10
1 files changed, 5 insertions, 5 deletions
diff --git a/src/_pgsql_utils b/src/_pgsql_utils
index dff7743..e119a2d 100644
--- a/src/_pgsql_utils
+++ b/src/_pgsql_utils
@@ -89,7 +89,7 @@ _pgsql_users () {
_pgsql_user_sql='select r.rolname from pg_catalog.pg_roles r where r.rolcanlogin = true'
- compadd "$@" - $( psql $_pgsql_params[@] -Aqt -c $_pgsql_user_sql template1 2>/dev/null )
+ compadd "$@" - $( psql $_pgsql_params[@] -XAqt -c $_pgsql_user_sql template1 2>/dev/null )
}
@@ -122,7 +122,7 @@ _pgsql_tables () {
order by 1"
compadd "$@" - \
- $( psql $_pgsql_params[@] -Aqt -c $_pgsql_table_sql $db 2>/dev/null )
+ $( psql $_pgsql_params[@] -AXqt -c $_pgsql_table_sql $db 2>/dev/null )
}
_pgsql_schemas () {
@@ -139,7 +139,7 @@ _pgsql_schemas () {
order by 1;"
compadd "$@" - \
- $( psql $_pgsql_params[@] -Aqt -c $_pgsql_schema_sql $db 2>/dev/null )
+ $( psql $_pgsql_params[@] -AXqt -c $_pgsql_schema_sql $db 2>/dev/null )
}
_pgsql_databases () {
@@ -160,7 +160,7 @@ _pgsql_databases () {
compadd "$@" - \
${(f)_pgsql_services} \
- $( psql $_pgsql_params[@] -Atq -c $_pgsql_db_sql template1 2>/dev/null )
+ $( psql $_pgsql_params[@] -AXtq -c $_pgsql_db_sql template1 2>/dev/null )
}
_pgsql_encodings () {
@@ -170,7 +170,7 @@ _pgsql_encodings () {
local _pgsql_db_sql
_pgsql_db_sql="select pg_encoding_to_char(i) from generate_series(0,100) i;"
- compadd "$@" - $( psql $_pgsql_params[@] -Atq -c $_pgsql_db_sql template1 )
+ compadd "$@" - $( psql $_pgsql_params[@] -AXtq -c $_pgsql_db_sql template1 )
}