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: | Whole Thread | Raw Message | 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
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 |