<feed xmlns='http://www.w3.org/2005/Atom'>
<title>zsh-completions/src/_pgsql_utils, branch update_cppcheck</title>
<subtitle>[no description]</subtitle>
<id>http://git.sudomsg.com/mirror/zsh-completions/atom/src/_pgsql_utils?h=update_cppcheck</id>
<link rel='self' href='http://git.sudomsg.com/mirror/zsh-completions/atom/src/_pgsql_utils?h=update_cppcheck'/>
<link rel='alternate' type='text/html' href='http://git.sudomsg.com/mirror/zsh-completions/'/>
<updated>2025-12-10T03:06:44Z</updated>
<entry>
<title>Remove postgres utility completions</title>
<updated>2025-12-10T03:06:44Z</updated>
<author>
<name>Shohei YOSHIDA</name>
<email>syohex@gmail.com</email>
</author>
<published>2025-12-10T03:05:01Z</published>
<link rel='alternate' type='text/html' href='http://git.sudomsg.com/mirror/zsh-completions/commit/?id=4e767d9139390a932af67c3a468c86409230d138'/>
<id>urn:sha1:4e767d9139390a932af67c3a468c86409230d138</id>
<content type='text'>
Because zsh supports those commands by itself now

See
 - https://github.com/zsh-users/zsh/blob/master/Completion/Unix/Command/_postgresql
</content>
</entry>
<entry>
<title>Fix typos</title>
<updated>2023-01-04T20:50:35Z</updated>
<author>
<name>Dimitris Apostolou</name>
<email>dimitris.apostolou@icloud.com</email>
</author>
<published>2023-01-04T20:50:35Z</published>
<link rel='alternate' type='text/html' href='http://git.sudomsg.com/mirror/zsh-completions/commit/?id=1d492c7151106a298f5c188369e04c3dce2b1366'/>
<id>urn:sha1:1d492c7151106a298f5c188369e04c3dce2b1366</id>
<content type='text'>
</content>
</entry>
<entry>
<title>Update links</title>
<updated>2022-11-23T04:31:48Z</updated>
<author>
<name>Shohei YOSHIDA</name>
<email>syohex@gmail.com</email>
</author>
<published>2022-11-23T04:23:19Z</published>
<link rel='alternate' type='text/html' href='http://git.sudomsg.com/mirror/zsh-completions/commit/?id=0b6e0648504382f68dbfc547bd4392a3d85e8513'/>
<id>urn:sha1:0b6e0648504382f68dbfc547bd4392a3d85e8513</id>
<content type='text'>
</content>
</entry>
<entry>
<title>Add additional PostgreSQL completions for 13+ and reorganize</title>
<updated>2022-01-27T22:23:03Z</updated>
<author>
<name>J Smith</name>
<email>dark.panda@gmail.com</email>
</author>
<published>2022-01-27T22:23:03Z</published>
<link rel='alternate' type='text/html' href='http://git.sudomsg.com/mirror/zsh-completions/commit/?id=406167058b5eb0495e75c5579e5be665cf211557'/>
<id>urn:sha1:406167058b5eb0495e75c5579e5be665cf211557</id>
<content type='text'>
</content>
</entry>
<entry>
<title>Merge pull request #749 from arp242/psqlrc</title>
<updated>2020-06-03T05:24:46Z</updated>
<author>
<name>Shohei YOSHIDA</name>
<email>syohex@gmail.com</email>
</author>
<published>2020-06-03T05:24:46Z</published>
<link rel='alternate' type='text/html' href='http://git.sudomsg.com/mirror/zsh-completions/commit/?id=3b247d3071b8f1b723f288aec10e91758a109045'/>
<id>urn:sha1:3b247d3071b8f1b723f288aec10e91758a109045</id>
<content type='text'>
pgsql: add -X to psql commands to prevent loading ~/.psqlrc</content>
</entry>
<entry>
<title>pgsql: Check for pg_config existence</title>
<updated>2020-06-03T04:33:45Z</updated>
<author>
<name>Martin Tournoij</name>
<email>martin@arp242.net</email>
</author>
<published>2020-06-03T03:24:41Z</published>
<link rel='alternate' type='text/html' href='http://git.sudomsg.com/mirror/zsh-completions/commit/?id=76efcab2f936fe375ad1106cd56c16a70137553d'/>
<id>urn:sha1:76efcab2f936fe375ad1106cd56c16a70137553d</id>
<content type='text'>
pg_config isn't installed by default on many systems, and is usually
part of postgresql-libs-devel or some such, leading to needless
"pg_config not found" errors on completion.
</content>
</entry>
<entry>
<title>pgsql: add -X to psql commands to prevent loading ~/.psqlrc</title>
<updated>2020-06-03T03:40:37Z</updated>
<author>
<name>Martin Tournoij</name>
<email>martin@arp242.net</email>
</author>
<published>2020-06-03T03:38:52Z</published>
<link rel='alternate' type='text/html' href='http://git.sudomsg.com/mirror/zsh-completions/commit/?id=f37143161905ca23bc5e2737dafae50b6c90e4ad'/>
<id>urn:sha1:f37143161905ca23bc5e2737dafae50b6c90e4ad</id>
<content type='text'>
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 &lt;&gt; 'information_schema' \
        order by 1;" postgres 2&gt;/dev/null

Gives the output:

    public
    Time: 1.882 ms

Whereas with -X it gives the standard output:

    public
</content>
</entry>
<entry>
<title>Fix typos</title>
<updated>2020-04-09T08:51:09Z</updated>
<author>
<name>Dimitris Apostolou</name>
<email>dimitris.apostolou@icloud.com</email>
</author>
<published>2020-04-08T22:19:36Z</published>
<link rel='alternate' type='text/html' href='http://git.sudomsg.com/mirror/zsh-completions/commit/?id=9e9bee7066c000957b674c3b68bb082eec58b410'/>
<id>urn:sha1:9e9bee7066c000957b674c3b68bb082eec58b410</id>
<content type='text'>
</content>
</entry>
<entry>
<title>Add additional PostgreSQL completions for PostgreSQL 12+</title>
<updated>2020-02-13T18:31:02Z</updated>
<author>
<name>J Smith</name>
<email>dark.panda@gmail.com</email>
</author>
<published>2020-02-11T16:13:04Z</published>
<link rel='alternate' type='text/html' href='http://git.sudomsg.com/mirror/zsh-completions/commit/?id=f46ec9befbdc17ccb1880498d06e003dbbb1eb40'/>
<id>urn:sha1:f46ec9befbdc17ccb1880498d06e003dbbb1eb40</id>
<content type='text'>
</content>
</entry>
<entry>
<title>Fix a syntax error on the PostgreSQL `createuser` utility</title>
<updated>2019-06-14T19:12:15Z</updated>
<author>
<name>J Smith</name>
<email>dark.panda@gmail.com</email>
</author>
<published>2019-06-14T19:11:51Z</published>
<link rel='alternate' type='text/html' href='http://git.sudomsg.com/mirror/zsh-completions/commit/?id=2ab70accf4c96599ba52ec775d94342c89988d86'/>
<id>urn:sha1:2ab70accf4c96599ba52ec775d94342c89988d86</id>
<content type='text'>
</content>
</entry>
<entry>
<title>#505: pg_restore accepts a file</title>
<updated>2018-10-13T21:39:52Z</updated>
<author>
<name>Julien Nicoulaud</name>
<email>julien.nicoulaud@gmail.com</email>
</author>
<published>2018-10-13T21:39:52Z</published>
<link rel='alternate' type='text/html' href='http://git.sudomsg.com/mirror/zsh-completions/commit/?id=c299511237dcb53ee1932ba4a0a417e283e218df'/>
<id>urn:sha1:c299511237dcb53ee1932ba4a0a417e283e218df</id>
<content type='text'>
</content>
</entry>
<entry>
<title>Add the --role option to the common pgsql options</title>
<updated>2017-08-28T14:51:58Z</updated>
<author>
<name>J Smith</name>
<email>dark.panda@gmail.com</email>
</author>
<published>2017-08-28T14:51:58Z</published>
<link rel='alternate' type='text/html' href='http://git.sudomsg.com/mirror/zsh-completions/commit/?id=bbd0fe91f4f4da68b1afebab4ae74ade1ff9c55c'/>
<id>urn:sha1:bbd0fe91f4f4da68b1afebab4ae74ade1ff9c55c</id>
<content type='text'>
</content>
</entry>
<entry>
<title>Add additional options for initdb</title>
<updated>2017-08-28T14:51:42Z</updated>
<author>
<name>J Smith</name>
<email>dark.panda@gmail.com</email>
</author>
<published>2017-08-28T14:50:55Z</published>
<link rel='alternate' type='text/html' href='http://git.sudomsg.com/mirror/zsh-completions/commit/?id=2a331231c5677a9aa70f859161238a2f813915fc'/>
<id>urn:sha1:2a331231c5677a9aa70f859161238a2f813915fc</id>
<content type='text'>
</content>
</entry>
<entry>
<title>Add the -i/--interactive option for dropuser</title>
<updated>2017-08-28T14:51:27Z</updated>
<author>
<name>J Smith</name>
<email>dark.panda@gmail.com</email>
</author>
<published>2017-08-28T14:50:21Z</published>
<link rel='alternate' type='text/html' href='http://git.sudomsg.com/mirror/zsh-completions/commit/?id=2653bb59a613228394e5a2a6256b429e457151b2'/>
<id>urn:sha1:2653bb59a613228394e5a2a6256b429e457151b2</id>
<content type='text'>
</content>
</entry>
<entry>
<title>Add additional options for createuser</title>
<updated>2017-08-28T14:50:02Z</updated>
<author>
<name>J Smith</name>
<email>dark.panda@gmail.com</email>
</author>
<published>2017-08-28T14:50:02Z</published>
<link rel='alternate' type='text/html' href='http://git.sudomsg.com/mirror/zsh-completions/commit/?id=48f3bb5beb61beb06555ceb181bb669f6d7fe242'/>
<id>urn:sha1:48f3bb5beb61beb06555ceb181bb669f6d7fe242</id>
<content type='text'>
</content>
</entry>
<entry>
<title>Add additional options for pg_dump</title>
<updated>2017-08-28T14:49:47Z</updated>
<author>
<name>J Smith</name>
<email>dark.panda@gmail.com</email>
</author>
<published>2017-08-28T14:49:47Z</published>
<link rel='alternate' type='text/html' href='http://git.sudomsg.com/mirror/zsh-completions/commit/?id=41bc851b84cb8d0b1bd8641dc28a640b871f8447'/>
<id>urn:sha1:41bc851b84cb8d0b1bd8641dc28a640b871f8447</id>
<content type='text'>
</content>
</entry>
<entry>
<title>Add additional options for psql</title>
<updated>2017-08-28T14:49:04Z</updated>
<author>
<name>J Smith</name>
<email>dark.panda@gmail.com</email>
</author>
<published>2017-08-28T14:49:04Z</published>
<link rel='alternate' type='text/html' href='http://git.sudomsg.com/mirror/zsh-completions/commit/?id=506972a1d6023f6c3819e2d3ae05d9ad7c6ef799'/>
<id>urn:sha1:506972a1d6023f6c3819e2d3ae05d9ad7c6ef799</id>
<content type='text'>
</content>
</entry>
<entry>
<title>#207: add license headers to compdefs from zsh-users mailing list</title>
<updated>2016-05-27T17:52:25Z</updated>
<author>
<name>Julien Nicoulaud</name>
<email>julien.nicoulaud@gmail.com</email>
</author>
<published>2016-05-27T17:52:25Z</published>
<link rel='alternate' type='text/html' href='http://git.sudomsg.com/mirror/zsh-completions/commit/?id=0f883ba365c8acafca3bc1f0c8ec9afd1cb40175'/>
<id>urn:sha1:0f883ba365c8acafca3bc1f0c8ec9afd1cb40175</id>
<content type='text'>
</content>
</entry>
<entry>
<title>Add service=... support to PostgreSQL completion</title>
<updated>2015-11-06T17:56:40Z</updated>
<author>
<name>Stefano Zacchiroli</name>
<email>zack@upsilon.cc</email>
</author>
<published>2015-11-06T17:56:40Z</published>
<link rel='alternate' type='text/html' href='http://git.sudomsg.com/mirror/zsh-completions/commit/?id=a812877745d4d3c1cedc66a8351f1b9909517f6c'/>
<id>urn:sha1:a812877745d4d3c1cedc66a8351f1b9909517f6c</id>
<content type='text'>
</content>
</entry>
<entry>
<title>pg_restore completion</title>
<updated>2015-06-29T01:40:18Z</updated>
<author>
<name>J Smith</name>
<email>dark.panda@gmail.com</email>
</author>
<published>2015-06-29T01:40:18Z</published>
<link rel='alternate' type='text/html' href='http://git.sudomsg.com/mirror/zsh-completions/commit/?id=705800ca20f8aee525dc1c25c59e94a96a670b3f'/>
<id>urn:sha1:705800ca20f8aee525dc1c25c59e94a96a670b3f</id>
<content type='text'>
</content>
</entry>
<entry>
<title>Correct misspellings</title>
<updated>2015-06-08T07:05:14Z</updated>
<author>
<name>Syohei YOSHIDA</name>
<email>syohex@gmail.com</email>
</author>
<published>2015-06-08T07:05:14Z</published>
<link rel='alternate' type='text/html' href='http://git.sudomsg.com/mirror/zsh-completions/commit/?id=d6fdb720e2b58ddd64b55c8d44740d13f799fff3'/>
<id>urn:sha1:d6fdb720e2b58ddd64b55c8d44740d13f799fff3</id>
<content type='text'>
</content>
</entry>
<entry>
<title>Fix typo in _pgsql_utils --disable-dollar-quoting</title>
<updated>2014-08-28T16:53:41Z</updated>
<author>
<name>Felix Bünemann</name>
<email>buenemann@louis.info</email>
</author>
<published>2014-08-28T16:53:41Z</published>
<link rel='alternate' type='text/html' href='http://git.sudomsg.com/mirror/zsh-completions/commit/?id=b405c9fae461aa6dad29c98da2884d9e54265dee'/>
<id>urn:sha1:b405c9fae461aa6dad29c98da2884d9e54265dee</id>
<content type='text'>
</content>
</entry>
<entry>
<title>pg_dumpall completion</title>
<updated>2012-09-21T13:24:37Z</updated>
<author>
<name>Daniel Serodio</name>
<email>dserodio@ig.com</email>
</author>
<published>2012-09-21T13:24:37Z</published>
<link rel='alternate' type='text/html' href='http://git.sudomsg.com/mirror/zsh-completions/commit/?id=e9f329421016aaa6b9740545c7df3e2f4d6e4533'/>
<id>urn:sha1:e9f329421016aaa6b9740545c7df3e2f4d6e4533</id>
<content type='text'>
</content>
</entry>
<entry>
<title>Add a bunch of additional options for pg_dump.</title>
<updated>2012-09-11T18:29:00Z</updated>
<author>
<name>J Smith</name>
<email>dark.panda@gmail.com</email>
</author>
<published>2012-09-10T20:40:33Z</published>
<link rel='alternate' type='text/html' href='http://git.sudomsg.com/mirror/zsh-completions/commit/?id=1b2dabcd2eed1cfc729812721721457cf440d4df'/>
<id>urn:sha1:1b2dabcd2eed1cfc729812721721457cf440d4df</id>
<content type='text'>
</content>
</entry>
<entry>
<title>Add the -T/--exclude-table option for pg_dump.</title>
<updated>2012-09-11T18:29:00Z</updated>
<author>
<name>J Smith</name>
<email>dark.panda@gmail.com</email>
</author>
<published>2012-09-10T20:38:07Z</published>
<link rel='alternate' type='text/html' href='http://git.sudomsg.com/mirror/zsh-completions/commit/?id=625eaa58ce693ddc5ddfebc2234817c17b6c3387'/>
<id>urn:sha1:625eaa58ce693ddc5ddfebc2234817c17b6c3387</id>
<content type='text'>
</content>
</entry>
<entry>
<title>Add the -N/--exclude-schema option for pg_dump.</title>
<updated>2012-09-11T18:29:00Z</updated>
<author>
<name>J Smith</name>
<email>dark.panda@gmail.com</email>
</author>
<published>2012-09-10T20:37:11Z</published>
<link rel='alternate' type='text/html' href='http://git.sudomsg.com/mirror/zsh-completions/commit/?id=d1e2e96be840f28fcf1516c9f61225f38ad75fc4'/>
<id>urn:sha1:d1e2e96be840f28fcf1516c9f61225f38ad75fc4</id>
<content type='text'>
</content>
</entry>
<entry>
<title>Add _pgsql_schemas to grab the list of schemas for pg_dump.</title>
<updated>2012-09-11T18:29:00Z</updated>
<author>
<name>J Smith</name>
<email>dark.panda@gmail.com</email>
</author>
<published>2012-09-10T20:36:27Z</published>
<link rel='alternate' type='text/html' href='http://git.sudomsg.com/mirror/zsh-completions/commit/?id=bc8ef1555755679a9ff03c4ea69cd4f2c02fc3c4'/>
<id>urn:sha1:bc8ef1555755679a9ff03c4ea69cd4f2c02fc3c4</id>
<content type='text'>
</content>
</entry>
<entry>
<title>Add the -E/--encoding option for pg_dump.</title>
<updated>2012-09-11T18:29:00Z</updated>
<author>
<name>J Smith</name>
<email>dark.panda@gmail.com</email>
</author>
<published>2012-09-10T20:20:56Z</published>
<link rel='alternate' type='text/html' href='http://git.sudomsg.com/mirror/zsh-completions/commit/?id=5921809d49e27ca6ed87c33a08d126c05da10488'/>
<id>urn:sha1:5921809d49e27ca6ed87c33a08d126c05da10488</id>
<content type='text'>
</content>
</entry>
<entry>
<title>Add the initdb command.</title>
<updated>2012-09-10T05:18:33Z</updated>
<author>
<name>J Smith</name>
<email>dark.panda@gmail.com</email>
</author>
<published>2012-09-10T05:02:50Z</published>
<link rel='alternate' type='text/html' href='http://git.sudomsg.com/mirror/zsh-completions/commit/?id=603bd2f4e17745509d9e3500059e56cb5eac96de'/>
<id>urn:sha1:603bd2f4e17745509d9e3500059e56cb5eac96de</id>
<content type='text'>
</content>
</entry>
<entry>
<title>Add the createuser and dropuser commands.</title>
<updated>2012-09-10T05:18:33Z</updated>
<author>
<name>J Smith</name>
<email>dark.panda@gmail.com</email>
</author>
<published>2012-09-10T05:02:26Z</published>
<link rel='alternate' type='text/html' href='http://git.sudomsg.com/mirror/zsh-completions/commit/?id=6b1c882e9dc7f3f69b1578fb0ba2e48877bc38ea'/>
<id>urn:sha1:6b1c882e9dc7f3f69b1578fb0ba2e48877bc38ea</id>
<content type='text'>
</content>
</entry>
<entry>
<title>Get the list of encodings from the database cluster.</title>
<updated>2012-09-10T05:18:33Z</updated>
<author>
<name>J Smith</name>
<email>dark.panda@gmail.com</email>
</author>
<published>2012-09-10T05:01:38Z</published>
<link rel='alternate' type='text/html' href='http://git.sudomsg.com/mirror/zsh-completions/commit/?id=cfb8da6fb2e5c34040bed02ad22f7e8ef1b73b2e'/>
<id>urn:sha1:cfb8da6fb2e5c34040bed02ad22f7e8ef1b73b2e</id>
<content type='text'>
</content>
</entry>
<entry>
<title>Connect to template1 when getting the list of databases.</title>
<updated>2012-09-10T05:18:33Z</updated>
<author>
<name>J Smith</name>
<email>dark.panda@gmail.com</email>
</author>
<published>2012-09-10T05:00:08Z</published>
<link rel='alternate' type='text/html' href='http://git.sudomsg.com/mirror/zsh-completions/commit/?id=c5a5033e0810dde8858b2aa10b15a3a883fb95d7'/>
<id>urn:sha1:c5a5033e0810dde8858b2aa10b15a3a883fb95d7</id>
<content type='text'>
We can't assume that the user will have a database that shares their
user name.
</content>
</entry>
<entry>
<title>Fix typo -- "oin" should be "oid".</title>
<updated>2012-09-10T05:18:33Z</updated>
<author>
<name>J Smith</name>
<email>dark.panda@gmail.com</email>
</author>
<published>2012-09-10T04:59:18Z</published>
<link rel='alternate' type='text/html' href='http://git.sudomsg.com/mirror/zsh-completions/commit/?id=98f5f1abc12dfa49ae5067a686d103a930a442e6'/>
<id>urn:sha1:98f5f1abc12dfa49ae5067a686d103a930a442e6</id>
<content type='text'>
</content>
</entry>
<entry>
<title>Move modelines to end of file</title>
<updated>2012-08-23T15:18:49Z</updated>
<author>
<name>Aaron Schrab</name>
<email>aaron@schrab.com</email>
</author>
<published>2012-08-23T15:18:49Z</published>
<link rel='alternate' type='text/html' href='http://git.sudomsg.com/mirror/zsh-completions/commit/?id=3f55429b0e97ff2ba57781abd9b529ac89d186b6'/>
<id>urn:sha1:3f55429b0e97ff2ba57781abd9b529ac89d186b6</id>
<content type='text'>
Having a vim modeline or emacs local variable line somewhere in the
middle of the file isn't really helpful.  By default, vim will only
check the first and last 5 lines of a file for a modeline (assuming the
modeline option is enabled).  Emacs is even more strict about the type
of local variable line that was in use, it will only check the first
line of the file or the second line if the first line specifies a script
interpreter (which isn't the case here).

Move the vim modeline to the end of the file so that it can actually be
found by vim but is out of the way for editing.  For emacs more work is
required, convert that to the more verbose Local Variables syntax which
emacs will look for starting 3000 characters from the end of the file.

Also there is no zsh mode for emacs (according to
zsh-users/zsh-completions#75), use the "Shell-Script" mode instead.
This seems to automatically detect that the files are for zsh.

I'm not an emacs user, so I haven't tested that portion much.  But, this
does at least improve the syntax highlighting there.
</content>
</entry>
<entry>
<title>[BREAKING CHANGE] Move compdefs to own directory (to ease packaging and</title>
<updated>2012-08-01T11:23:11Z</updated>
<author>
<name>Julien Nicoulaud</name>
<email>julien.nicoulaud@gmail.com</email>
</author>
<published>2012-08-01T11:23:11Z</published>
<link rel='alternate' type='text/html' href='http://git.sudomsg.com/mirror/zsh-completions/commit/?id=10ffeb0c153258896531b2b8939e94486d58b378'/>
<id>urn:sha1:10ffeb0c153258896531b2b8939e94486d58b378</id>
<content type='text'>
avoid bloating users fpath with unneeded files such as README.md)
</content>
</entry>
</feed>
