Re: Novice Question

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(at)postgresql(dot)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