From: | "Sean Davis" <sdavis2(at)mail(dot)nih(dot)gov> |
---|---|
To: | "Daniel Malcolm Webb [dbw]" <dbw(at)aber(dot)ac(dot)uk> |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: FW: Dumping a query result to a table |
Date: | 2008-10-22 14:04:50 |
Message-ID: | 264855a00810220704l11baaa6g12caf2e166c571d7@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
On Wed, Oct 22, 2008 at 9:56 AM, Daniel Malcolm Webb [dbw]
<dbw(at)aber(dot)ac(dot)uk> wrote:
> Hi all,
>
>
>
> I've been searching for the answer to this question but Google is not
> playing ball. Basically I have a terrible database adaptor (long story, but
> basically all I can use at the moment) for Ruby that doesn't seem to be
> compatible with PSQL 8.3, and so I can't run this query below from it. So
> best thing to do I thought would be to dump the results of the query to a
> single table and just query that table. Is this possible? (and yes this
> query is a mess and is returning too many rows at the moment)
create table newtable as ....
> SELECT question_stem, option_text, author_id, QR.module_code, correct,
> weighting, question_option.option_id, feedback FROM question Q
>
> LEFT JOIN assessment_question_option_stat AQO
>
> ON AQO.question_id = Q.question_id
>
> LEFT JOIN question_module
>
> ON question_module.question_id = Q.question_id
>
> LEFT JOIN question_option
>
> ON question_option.question_id = Q.question_id
>
> LEFT JOIN question_response QR
>
> ON QR.question_id = Q.question_id
>
> LEFT JOIN question_objective
>
> ON question_objective.question_id = Q.question_id
>
> LEFT JOIN question_keyword qk
>
> ON qk.question_id = Q.question_id
>
>
>
>
>
> Kind Regards,
>
> Dan Webb
>
> ____________________________________________________________
>
> Swyddog Datblygu a Chynnal Systemau Gwybodaeth
>
> Information Systems Development & Support Officer
>
>
>
> Gwasanaethau Gwybodaeth Information Services
>
> Prifysgol Aberystwyth Aberystwyth University
>
>
>
> E-bost / E-mail: dbw(at)aber(dot)ac(dot)uk
>
> Ffon / Tel: (01970) 628408
>
> ____________________________________________________________
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Daniel Malcolm Webb [dbw] | 2008-10-22 14:08:52 | Re: FW: Dumping a query result to a table |
Previous Message | Daniel Malcolm Webb [dbw] | 2008-10-22 13:56:03 | FW: Dumping a query result to a table |