Re: exporting join results

Поиск
Список
Период
Сортировка
От Fernando Schapachnik
Тема Re: exporting join results
Дата
Msg-id 20030529160716.GF620@bal740r0.mecon.gov.ar
обсуждение исходный текст
Ответ на exporting join results  (Roy Cabaniss <rcaban@cabanisspc.uamont.edu>)
Ответы Re: exporting join results  (Roy Cabaniss <rcaban@cabanisspc.uamont.edu>)
Список pgsql-general
Either create a view and access it from an spreadsheet via ODBC, or SELECT INTO
another table, then dump it.

Good luck.

Fernando.

En un mensaje anterior, Roy Cabaniss escribió:
> 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.

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

Предыдущее
От: Roy Cabaniss
Дата:
Сообщение: exporting join results
Следующее
От: "scott.marlowe"
Дата:
Сообщение: Re: Postmaster only takes 4-5% CPU