Re: [GENERAL] temporary tables - Mailing list pgsql-general

From Mike Mascari
Subject Re: [GENERAL] temporary tables
Date
Msg-id 38AA8B01.1C269F61@mascari.com
Whole thread Raw
In response to temporary tables  ("sheila bel" <sheilabel@hotmail.com>)
List pgsql-general
sheila bel wrote:
>
> Hi everyone,
>
> The data that needs to be copied is either text or password.
> This is what I think should be done please correct me if
> its wrong :
> COPY temptable(attributes) To permanent_table(attributes);
>
> If someone could give me an example I would really appreciate
> it.
>
> -Sheila

INSERT INTO permanent_table SELECT * from temptable;

Hope that helps,

Mike Mascari

pgsql-general by date:

Previous
From: "omid omoomi"
Date:
Subject: Re: [GENERAL] temporary tables
Next
From: Bruce Momjian
Date:
Subject: Re: [GENERAL] temporary tables