Re: How to copy table?

From: jdassen(at)cistron(dot)nl (J(dot)H(dot)M(dot) Dassen (Ray))
To: pgsql-general(at)postgresql(dot)org
Subject: Re: How to copy table?
Date: 2001-03-22 09:12:42
Message-ID: slrn9bjgga.rsf.jdassen@odin.cistron-office.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Jeff <jklcom(at)mindspring(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message DaVinci 2001-03-22 09:15:54 transaction aborted with error
Previous Message Joshua Drake 2001-03-22 08:05:07 UPDATED: PR - PostgreSQL: The Elephant Never forgets