[GENERAL] psql feature request: --list-conninfo (dump the config info psql would use to connect)

2014-12-22 Thread David Johnston
Hi! When psql (libpq) connects it uses a combination of defaults, environment variables, command line arguments, and possibly a pg_service file to figure out where it is going to connect, and how. Specifying the option "--list-conninfo" as an option would cause psql to simply output all of the va

[GENERAL] psql feature request

2011-07-12 Thread Wim Bertels
Hallo, psql feature request i would be nice if /o file_with_less.txt for redirecting output to a file could contain the same info as the logfile psql -a -L file_with_more.txt (and -eE if u need it) option -a echo's all, but this info doesn't get written to /o file_with_less.txt why? within on

Re: [GENERAL] psql feature request (\dd+)

2010-05-14 Thread Tom Lane
Craig Ringer writes: > What gets me with Pg's COMMENT ON is the way the comments have to be > separate from, and after, the objects they refer to. IMO it'd be > significantly preferable to have something like: > CREATE TABLE X ( > somepk integer primary key, > cost numeric(10,2) COMMENT

Re: [GENERAL] psql feature request (\dd+)

2010-05-14 Thread Craig Ringer
On 14/05/2010 11:35 PM, Richard Broersma wrote: It'd be nice if there was a \dd+ command to return all of the comments of dependent objects in addition to the specified object; i.e. all dependent objects related to a table for example. What gets me with Pg's COMMENT ON is the way the comments

[GENERAL] psql feature request (\dd+)

2010-05-14 Thread Richard Broersma
It'd be nice if there was a \dd+ command to return all of the comments of dependent objects in addition to the specified object; i.e. all dependent objects related to a table for example. Notice the difference between difference between a well documented DDL script versus the results returned by