BUG #14374: psql.exe command options \dtvs produces a database list, not table/view/sequences.
The following bug has been logged on the website:
Bug reference: 14374
Logged by: Anup Saund
Email address: anup.saund@gmail.com
PostgreSQL version: 9.6.0
Operating system: Windows 7 (64bit)
Description:
SCREENSHOT OF OUTPUT
====================
https://dl.dropboxusercontent.com/u/312296/output.PNG
Test Scenario
=============
PostgreSQL - 9.4 was already installed.
Running the following command would produce an output as per the screenshot
above.
CD c:\Program Files\PostgreSQL
.\9.4\bin\psql.exe -ltU postgres -p 5433 -h localhost -d dellstore2 -c
"\dtvs""
Issue
=====
Running the same command after installing 9.6.0 would give a list a
databases, not tables/views/sequences.
.\9.6\bin\psql.exe -ltU postgres -p 5433 -h localhost -d dellstore2 -c
"\dtvs""
Also tested with PostgreSQL version 9.5 - that version does produce the same
output as 9.4.
Unfortunately, I cannot get the commands to work with 9.6.
I have read over the documentation but that specific section is suggesting
the same usage as 9.5/9.4.
Any help would be greatly appreciated.
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
anup.saund@gmail.com writes:
Running the same command after installing 9.6.0 would give a list a
databases, not tables/views/sequences.
.\9.6\bin\psql.exe -ltU postgres -p 5433 -h localhost -d dellstore2 -c
"\dtvs""
I don't think this is a bug. -l is documented as "list available
databases, then exit". It's not specified whether that takes preference
over -c or not. The changes in 9.6 to make -c act more like -f evidently
caused it to not take precedence over -l anymore, and that seems fine
from here.
regards, tom lane
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs