Postgres Pro
Downloads
Home   >   mailing lists

Re: new table with a select - Mailing list pgsql-sql

From MIkhail Puzanov
Subject Re: new table with a select
Date
Msg-id CAJWC0jD_qEo0RhiMYe8H2ougkCd=fabQW09djW7GHrns493dnw@mail.gmail.com
Whole thread Raw
In response to new table with a select  (ppdcc@sapo.pt)
List pgsql-sql
Tree view
Hi,


2011/8/25 <ppdcc@sapo.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;

pgsql-sql by date:

Previous
From: ppdcc@sapo.pt
Date:
Subject: new table with a select
Next
From: Jan Eskilsson
Date:
Subject: Re: [ADMIN] parsing audit table