Postgres Pro
Downloads
Home   >   mailing lists

Thread: Duplicating A Row

Duplicating A Row

From
"Jeff Flowers"
Date:
Is there an easy way to duplicate a row within a table?

--
Jeff Flowers

Re: Duplicating A Row

From
Tom Lane
Date:
"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

Re: Duplicating A Row

From
Jeffrey Melloy
Date:
Jeff Flowers wrote:

>Is there an easy way to duplicate a row within a table?
>
>
>
clueless users?

Jeff