Re: psql > split > queries & output

2020-12-04 Thread Wim Bertels
Daniel Verite schreef op do 03-12-2020 om 16:32 [+0100]: > Wim Bertels wrote: > > > but interactively this doesn't seem to work > > Interactively something like this might do the job: > > $ PSQL_HISTORY=/tmp/queries.txt psql -L /tmp/logfile.txt > > After running some queries, and a clea

Re: psql > split > queries & output

2020-12-03 Thread Wim Bertels
Daniel Verite schreef op do 03-12-2020 om 15:18 [+0100]: > Wim Bertels wrote: > > > * one pipe (or..) to a file which only contains the statements > > (queries) history (and not the output) > > * another pipe (or..) to a file which only contains the output > > (with or > > without the statem

Re: psql > split > queries & output

2020-12-03 Thread Pavel Stehule
čt 3. 12. 2020 v 12:39 odesílatel Wim Bertels napsal: > Hello, > > psql shows (the queries and) the output, > there are for example the -L option and echo_queries option > > is there a way to run psql so that: > * inside psql there are no surprises :) (ignore this line:) > * one pipe (or..) to a

psql > split > queries & output

2020-12-03 Thread Wim Bertels
Hello, psql shows (the queries and) the output, there are for example the -L option and echo_queries option is there a way to run psql so that: * inside psql there are no surprises :) (ignore this line:) * one pipe (or..) to a file which only contains the statements (queries) history (and not the