Re: new table with a select

From: MIkhail Puzanov <misha(dot)puzanov(at)gmail(dot)com>
To: ppdcc(at)sapo(dot)pt
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: new table with a select
Date: 2011-08-26 07:06:23
Message-ID: CAJWC0jD_qEo0RhiMYe8H2ougkCd=fabQW09djW7GHrns493dnw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi,

2011/8/25 <ppdcc(at)sapo(dot)pt>

> Hello to all,
>
>
> Can anybody tell me the sql instruction to create a new table with a select
> of other table?
>
> I need to create a new table based on paralell of a table of lines. Can
> anybody post to me a example?
>
>
CREATE TABLE t AS
SELECT * FROM x;

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Jan Eskilsson 2011-08-28 10:00:21 Re: [SQL] parsing audit table
Previous Message Craig Ringer 2011-08-26 03:51:36 Re: (pgsql8.4) DATA Corruption