create table foo as select * from bar; just add "where 1=2" if you just want the schema
On 08/25/2011 11:44, pp...@sapo.pt wrote:
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
-- No trees were killed in the creation of this message. However, many electrons were terribly inconvenienced.
<<attachment: jcigar.vcf>>
-- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
