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: (view raw or whole 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;
> 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. 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-2015 The PostgreSQL Global Development Group