Re: exporting join results

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