exporting join results

Поиск
Список
Период
Сортировка
От Roy Cabaniss
Тема exporting join results
Дата
Msg-id 1054223676.14672.8.camel@cabanisspc.uamont.edu
обсуждение исходный текст
Ответы Re: exporting join results  (Fernando Schapachnik <fernando@mecon.gov.ar>)
Re: exporting join results  ("scott.marlowe" <scott.marlowe@ihs.com>)
Re: exporting join results  (Bruno Wolff III <bruno@wolff.to>)
Список pgsql-general
I have some tables that I am gathering data in.  Some of the data
gathered goes into personal table and the survey results goes into the
survey table.

I can do a join with no problem to see my results with something like:

select * from personal,survey WHERE personal.pid=survey.pid;

I can do a dump of either table again with no problem.

What I want is to get a dump of the join as a comma separated text file
so that I can import it into my statistical software.

Any ideas on how to do it?

Thanks for the help.

--
Dr. Roy F. Cabaniss
Associate Professor of Marketing
University of Arkansas Monticello
http://cabanisspc.uamont.edu


В списке pgsql-general по дате отправления:

Предыдущее
От: Network Administrator
Дата:
Сообщение: Re: pgAdmin3 snapshots
Следующее
От: Fernando Schapachnik
Дата:
Сообщение: Re: exporting join results