Postgres Pro
Downloads
Home   >   mailing lists

Re: Duplicating A Row - Mailing list pgsql-novice

From Tom Lane
Subject Re: Duplicating A Row
Date
Msg-id 29897.1101400505@sss.pgh.pa.us
Whole thread Raw
In response to Duplicating A Row  ("Jeff Flowers" <duckfoo@fastmail.fm>)
List pgsql-novice
Tree view 
"Jeff Flowers" <duckfoo@fastmail.fm> writes:
> Is there an easy way to duplicate a row within a table?

INSERT INTO foo SELECT * FROM foo WHERE some-conditions;

            regards, tom lane

pgsql-novice by date:

Previous
From: "Jeff Flowers"
Date:
Subject: Duplicating A Row
Next
From: "Alexander Jochum"
Date:
Subject: problem with accessing or creating a database..