select into ...outfile

From: Clinton Adams <clinton(at)vote-smart(dot)org>
To: pgsql-novice(at)postgresql(dot)org
Subject: select into ...outfile
Date: 2002-03-01 22:50:51
Message-ID: 5.0.2.1.0.20020301153609.0382ce98@mail.vote-smart.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice


I need to generate text files from queries. In mysql this was SELECT INTO
OUTFILE. Is it a two step process with postgres - SELECT INTO TEMPORARY
TABLE then COPY TABLE?

/clinton

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Oliver Elphick 2002-03-01 23:38:19 Re: select into ...outfile
Previous Message Josh Berkus 2002-03-01 17:47:46 Re: COPY function and error log