Обсуждение: how to generate a sql file

Поиск
Список
Период
Сортировка

how to generate a sql file

От
spambox
Дата:
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

От
Richard Huxton
Дата:
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