Feature request psql

From: Wim Bertels <wim(dot)bertels(at)khleuven(dot)be>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Feature request psql
Date: 2011-04-19 11:56:11
Message-ID: 1303214171.25698.37.camel@zwerfkat
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hallo,

i have a possible feature request.

It is not possible to get the sql statement itself and the output of the
statement in a user-friendly way to an output file (option \o psql),
this is only possible outside of psql, when calling this function with
an option -L (psql -L log.txt).
The nice thing about the option \o is that u can use multiple output
files with different markups in 1 script.

An example
with \o file1 option one can only get in file1
"
ECHO queries

SET

SET

cid
lid
seq
status
lang
payload
DM
SEL
1
None
NL
inleiding
"

while having at the same time in logfile (option psql -L logfile)
"
********* QUERY **********
SET SESSION AUTHORIZATION test;
**************************

SET
********* QUERY **********
SET search_path TO elswim;
**************************

SET
********* QUERY **********
SELECT *
FROM get_overview();
**************************

cid | lid | seq | status | lang | payload
-----+--------+-----+--------+------+-----------------------------------------------
DM | SEL | 1 | None | NL | inleiding
(1 row)
"

basically, the echo command doesnt get written to the file1 (of \o file1)

mvg,
Wim

Browse pgsql-general by date

  From Date Subject
Next Message mark 2011-04-19 13:17:05 Re: How to configure a read-only database server and session? (Was: read-only UNLOGGED tables)
Previous Message Frank van Vugt 2011-04-19 10:39:52 Re: REASSIGN OWNED doesn't for all objects, ALTER FUNCTION seems to fix it