Re: [GENERAL] How to copy a table?

[Zak McGregor]

On Mon, 26 Mar 2001 21:21:12 -0500
"Jeff" <[EMAIL PROTECTED]> wrote:

> Hi,
> 
> Can some one show me what's the best way to backup a table or copy a table?

Backing up is simple with pg_dump and pg_dumpall.

Copying a table (assuming within the same database) is also easy:

create table test as select * from other_table;


HTH

Zak

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]