| From: | Jeff Eckermann <jeff_eckermann(at)yahoo(dot)com> |
|---|---|
| To: | Roy Cabaniss <rcaban(at)cabanisspc(dot)uamont(dot)edu> |
| Cc: | pgsql pgsql <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: exporting join results |
| Date: | 2003-05-29 18:31:43 |
| Message-ID: | 20030529183143.67916.qmail@web20802.mail.yahoo.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruno Wolff III | 2003-05-29 18:39:52 | Re: Blocking access to the database?? |
| Previous Message | Andrew Sullivan | 2003-05-29 18:31:04 | Re: Moving a table to a different schema |