Postgres Pro
Downloads
Home   >   mailing lists

Re: How to copy a table? - Mailing list pgsql-general

From Zak McGregor
Subject Re: How to copy a table?
Date
Msg-id 200103270337.FAA03309@zak.home.dom
Whole thread Raw
In response to How to copy a table?  ("Jeff" <jklcom@mindspring.com>)
List pgsql-general
Tree view 
On Mon, 26 Mar 2001 21:21:12 -0500
"Jeff" <jklcom@mindspring.com> 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

pgsql-general by date:

Previous
From: Zak McGregor
Date:
Subject: Re: How to auto create a unique key for each newly added record?
Next
From: Larry Rosenman
Date:
Subject: Re: records zapped to null