Re: exporting join results

Поиск
Список
Период
Сортировка
От Jeff Eckermann
Тема Re: exporting join results
Дата
Msg-id 20030529183143.67916.qmail@web20802.mail.yahoo.com
обсуждение исходный текст
Ответ на Re: exporting join results  ("scott.marlowe" <scott.marlowe@ihs.com>)
Список 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 по дате отправления:

Предыдущее
От: Andrew Sullivan
Дата:
Сообщение: Re: Moving a table to a different schema
Следующее
От: Bruno Wolff III
Дата:
Сообщение: Re: Blocking access to the database??