Postgres Pro
Downloads
Home   >   mailing lists

how to duplicate data for few times by SQL command in PG - Mailing list pgsql-general

From tsunghan hsieh
Subject how to duplicate data for few times by SQL command in PG
Date
Msg-id CAFypHLy=TU63JJJFofETUP_T8Dg3G7b6WZN0DR=R-Cmnvgvmpg@mail.gmail.com
Whole thread Raw
Responses Re: how to duplicate data for few times by SQL command in PG  (Raymond O'Donnell <rod@iol.ie>)
List pgsql-general
Tree view
Hi

I have a table which just has one column as following in Original Table. I wanna duplicate all of data for few times and with same order as following in New Table. Is there anyone who can help me? Thanks

Han

Original Table
23
45
65
22

New Table
23
23
23
45
45
45
65
65
65
65
22
22
22
22

pgsql-general by date:

Previous
From: "Felix Kunde"
Date:
Subject: Re: Getting a delta of two json-typed objects? (a breeze w/ hstore)
Next
From: agent
Date:
Subject: Re: BDR Error restarted