On 29 May 2003, Roy Cabaniss wrote:
> 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?
join into another table, then export that table.
In response to
pgsql-general by date
|Next:||From: Jim C. Nasby||Date: 2003-05-29 16:14:22|
|Subject: Moving a table to a different schema|
|Previous:||From: Fernando Schapachnik||Date: 2003-05-29 16:07:16|
|Subject: Re: exporting join results|