Postgres Pro
Downloads
Home   >   mailing lists

Re: Copying a column into a temp. table - Mailing list pgsql-general

From Gabriele Bartolini
Subject Re: Copying a column into a temp. table
Date
Msg-id 4CA5E8D3.80705@2ndQuadrant.it
Whole thread Raw
In response to Copying a column into a temp. table  (Alexander Farber <alexander.farber@gmail.com>)
List pgsql-general
Tree view 
  Hi Alex,
> Of course "select ... into" doesn't work, but how should I do it?
> Can't find in http://www.postgresql.org/docs/8.1/static/
>
You might want to look at the CREATE TABLE AS command. You might even
use the temporary definer.

Ciao,
Gabriele

--
  Gabriele Bartolini - 2ndQuadrant Italia
  PostgreSQL Training, Services and Support
  gabriele.bartolini@2ndQuadrant.it | www.2ndQuadrant.it

pgsql-general by date:

Previous
From: Alexander Farber
Date:
Subject: Copying a column into a temp. table
Next
From: Adrian Klaver
Date:
Subject: Re: Copying a column into a temp. table