Postgres Pro
Downloads
Home   >   mailing lists

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

From jdassen@cistron.nl (J.H.M. Dassen (Ray))
Subject Re: How to copy table?
Date
Msg-id slrn9bjgga.rsf.jdassen@odin.cistron-office.nl
Whole thread Raw
In response to How to copy table?  ("Jeff" <jklcom@mindspring.com>)
List pgsql-general
Tree view 
Jeff <jklcom@mindspring.com> wrote:
>How can I copy a table or backup a table within a database?

SELECT * INTO TABLE newtable FROM originaltable;

HTH,
Ray
--
I'm having trouble keeping my clever schemes separate from my sarcasm.
    Wally

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: regress test errors
Next
From: jdassen@cistron.nl (J.H.M. Dassen (Ray))
Date:
Subject: Re: Updates on Views?