Re: FW: Dumping a query result to a table

Thank you I could possibly kiss you.

Thanks,
Dan

-----Original Message-----
From: seandavi(at)gmail(dot)com [mailto:seandavi(at)gmail(dot)com] On Behalf Of Sean Davis
Sent: 22 October 2008 15:05
To: Daniel Malcolm Webb [dbw]
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: [NOVICE] FW: Dumping a query result to a table

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
>
> ____________________________________________________________
>
>