Re: Help: How to store query output in a file !!!

From: selkovjr(at)mcs(dot)anl(dot)gov
To: NEERAJ BANSAL <nbansal1(at)email(dot)mot(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Help: How to store query output in a file !!!
Date: 2000-06-14 07:08:17
Message-ID: 200006140745.CAA20028@mail.xnet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)hotmail(dot)com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Barnes 2000-06-14 10:56:26 RE: PostgreSQL and multiple database access
Previous Message selkovjr 2000-06-14 07:00:46 Re: Size Limit