Re: Select dump

From: Geoffrey <esoteric(at)3times25(dot)net>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Select dump
Date: 2005-05-11 13:59:15
Message-ID: 42820FB3.7070408@3times25.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

SG Edwards wrote:
> Hi,
>
> Quick question for 10 points!
>
> Is there a way to write the output of a select query to a file (I'm on a linux
> platform)?
>
> For example:
>
> SELECT name, age, address from employee;
>
> gives the result that I want to write to a text file:

From what interface? You can do this from psql:

echo 'select foo from bar;' | psql database > select.out

--
Until later, Geoffrey

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2005-05-11 14:05:02 Re: First plpgsql Script
Previous Message Van Ingen, Lane 2005-05-11 13:53:50 First plpgsql Script