Sean Davis wrote:
>
> On Mar 1, 2005, at 4:23 PM, Michael Romagnoli wrote:
>
>>
>> I am new to postgresql, having previously worked with mysql mostly.
>>
>> What kind of command would I run if I wanted to copy an entire table
>> (along with renaming it, and, of course, all data from the first table
>> - some of which is binary)?
>>
>> Thanks,
>>
>> -Mike
>>
>> ---------------------------(end of broadcast)---------------------------
>> TIP 3: if posting/reading through Usenet, please send an appropriate
>> subscribe-nomail command to majordomo@postgresql.org so that your
>> message can get through to the mailing list cleanly
>
>
> select * into table new_table from old_table;
>
> That's it.
>
> Sean
>
you sure about that syntax?
How about:
create table new_table as select * from old_table;
--
_______________________________
This e-mail may be privileged and/or confidential, and the sender does
not waive any related rights and obligations. Any distribution, use or
copying of this e-mail or the information it contains by other than an
intended recipient is unauthorized. If you received this e-mail in
error, please advise me (by return e-mail or otherwise) immediately.
_______________________________
