Thread: getting query result into a file

Hi,
Please , can i get a postgresql query result into a
file using for my application ? why?
thank's

___________________________________________________________
Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français !
Yahoo! Mail : http://fr.mail.yahoo.com

Etienne Noumedem wrote:
> Hi,
> Please , can i get a postgresql query result into a
> file using for my application ? why?
> thank's

Sure, psql -o file or \g filename.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

On Tue, Dec 03, 2002 at 12:13:50 +0100,
  Etienne Noumedem <etienduval@yahoo.fr> wrote:
> Hi,
> Please , can i get a postgresql query result into a
> file using for my application ? why?
> thank's

If you are using the psql interface you can use the \o command to redirect
output to a file.