getting query result into a file

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

getting query result into a file

От:
Etienne Noumedem <etienduval@yahoo.fr>
Дата:
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

Re: getting query result into a file

От:
Bruce Momjian <pgman@candle.pha.pa.us>
Дата:
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

Re: getting query result into a file

От:
Bruno Wolff III <bruno@wolff.to>
Дата:
On Tue, Dec 03, 2002 at 12:13:50 +0100,
  Etienne Noumedem  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.
FAQ