Re: how to generate a sql file

From: Richard Huxton <dev(at)archonet(dot)com>
To: spambox(at)wanadoo(dot)fr, pgsql-general(at)postgresql(dot)org
Subject: Re: how to generate a sql file
Date: 2004-03-23 11:52:14
Message-ID: 200403231152.14661.dev@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ian Harding 2004-03-23 15:11:25 Re: PHP or JSP? That is the question.
Previous Message lnd 2004-03-23 10:40:36 Re: PHP or JSP? That is the question.