Outputting select into file.

From: Troy(dot)Campano(at)LibertyMutual(dot)com
To: pgsql-general(at)postgresql(dot)org
Subject: Outputting select into file.
Date: 2001-12-19 15:06:06
Message-ID: 9534B16F750ED2118CF90008C724C4460C22235B@lmig-msg-20.lmig.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

I have postgres 7 running on RedHat Linux.

I was wondering if you knew of a way to run a select and output it to a
file.

For example

SELECT * FROM TABLE >> test.out

So that test.out would have the results from that SQL Statement.

Thank you for your time,

Troy Campano

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2001-12-19 15:11:51 Re: Stupid question on INDEXES
Previous Message Joe Koenig 2001-12-19 14:44:23 Re: Way to use count() and LIMIT?