create table foo as select * from bar;
just add "where 1=2" if you just want the schema
On 08/25/2011 11:44, ppdcc@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.