Re: Help: How to store query output in a file !!! - Mailing list pgsql-general

From selkovjr@mcs.anl.gov
Subject Re: Help: How to store query output in a file !!!
Date
Msg-id 200006140745.CAA20028@mail.xnet.com
Whole thread Raw
In response to Help: How to store query output in a file !!!  (NEERAJ BANSAL <nbansal1@email.mot.com>)
List pgsql-general
>
> Does anyone knows how do you send query output to a file???

Welcome to Unix(TM):

psql <database> -c "select * from <table name>, etc." > <file name>

See also:

http://www.isu.edu/departments/comcom/unix/workshop/io.html

or, type "unix tutorial" in any web search engine.

--Gene

> I tried following but it does not work:
> select * from <table name> \o <file name> ;
>
> Please let me know if anyone knows!! Thanks in advance
>
> Neeraj
> neeraj_b@hotmail.com


pgsql-general by date:

Previous
From: selkovjr@mcs.anl.gov
Date:
Subject: Re: Size Limit
Next
From: "Barnes"
Date:
Subject: RE: PostgreSQL and multiple database access