Re: exporting join results - Mailing list pgsql-general

From Jeff Eckermann
Subject Re: exporting join results
Date
Msg-id 20030529183143.67916.qmail@web20802.mail.yahoo.com
Whole thread Raw
In response to Re: exporting join results  ("scott.marlowe" <scott.marlowe@ihs.com>)
List pgsql-general
If you don't want to deal with another table that
holds all of your data, you could export the data
using a query with a few psql commands.

\a  -- unaligned output, i.e. without space padding
\f ','  -- specify comma field separator
\t    -- tuples (i.e. data) only, if that is what you
want
\o filename  -- destination file for your data

Now run your query, and you should have what you want.
 Shouldn't be too hard to make a script out of that.

__________________________________
Do you Yahoo!?
Yahoo! Calendar - Free online calendar with sync to Outlook(TM).
http://calendar.yahoo.com

pgsql-general by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: Moving a table to a different schema
Next
From: Bruno Wolff III
Date:
Subject: Re: Blocking access to the database??