Postgres Pro
Downloads
Home   >   mailing lists

Thread: new table with a select

new table with a select

From
ppdcc@sapo.pt
Date:
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?

Can?t be a buffer, must be lines.

Thanks

Re: new table with a select

From
MIkhail Puzanov
Date:
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;