Thread: how to generate a sql file

how to generate a sql file

From
spambox
Date:
Hi,

i would like to generate a file of my sql sequences during a stored
process, i know it's possible but i dont' find the command.
Thx for the help

Re: how to generate a sql file

From
Richard Huxton
Date:
On Tuesday 23 March 2004 09:11, spambox wrote:
> Hi,
>
> i would like to generate a file of my sql sequences during a stored
> process, i know it's possible but i dont' find the command.
> Thx for the help

Well, from psql \o <filename> will output results to a file.

If it's the statements you want to record, set the log_statement config
setting (see run-time environment section of the manuals).

--
  Richard Huxton
  Archonet Ltd