Skip site navigation (1) Skip section navigation (2)

Re: exporting join results

From: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>
To: Roy Cabaniss <rcaban(at)cabanisspc(dot)uamont(dot)edu>
Cc: pgsql pgsql <pgsql-general(at)postgresql(dot)org>
Subject: Re: exporting join results
Date: 2003-05-29 16:11:00
Message-ID: Pine.LNX.4.33.0305291010350.29552-100000@css120.ihs.com (view raw or flat)
Thread:
Lists: pgsql-general
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

Responses

pgsql-general by date

Next:From: Jim C. NasbyDate: 2003-05-29 16:14:22
Subject: Moving a table to a different schema
Previous:From: Fernando SchapachnikDate: 2003-05-29 16:07:16
Subject: Re: exporting join results

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group