Fwd: [GENERAL] Novice Question

Begin forwarded message:

> From: Sean Davis <sdavis2(at)mail(dot)nih(dot)gov>
> Date: March 1, 2005 4:40:56 PM EST
> To: Michael Romagnoli <michael(at)houseind(dot)com>
> Subject: Re: [GENERAL] Novice Question

> On newer versions of pg, I think you can use pg_dump. Check the docs
> for the details....
>
> http://www.postgresql.org/docs/current/static/backup.html
>
> Sean
>
> On Mar 1, 2005, at 4:36 PM, Michael Romagnoli wrote:
>
>> 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(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.
>>
>>
>> Thanks - and I apologize, but I put in the wrong reference, I meant
>> databases, not tables. And the data from the databases have binary
>> data in them.
>>
>> :\
>>
>> Thanks for your help,
>>
>> Mike