Postgres Pro
Downloads
Home   >   mailing lists

Re: reduce number of multiple values to be inserted - Mailing list pgsql-general

From David G. Johnston
Subject Re: reduce number of multiple values to be inserted
Date
Msg-id CAKFQuwaTyOocntQF2htrM-GMFCwAsi5osMHTE8XiUDvWDu8giQ@mail.gmail.com
Whole thread Raw
In response to reduce number of multiple values to be inserted  (tango ward <tangoward15@gmail.com>)
Responses Re: reduce number of multiple values to be inserted  (tango ward <tangoward15@gmail.com>)
List pgsql-general
Tree view
On Tuesday, May 29, 2018, tango ward <tangoward15@gmail.com> wrote:
I will repeat the same process for 13 villages so that will be 117 of values. I would like to know if there's a way to reduce the script? This has to be done strictly via script.


VALUES and CROSS JOIN might help but you haven't explained the pattern well enough, if there is one, to know for sure.  Frankly, you'll probably spend more time figuring out the elegant way than just copy-paste-change so unless you need to leverage this elsewhere I'd say just brute-force it.

David J.

pgsql-general by date:

Previous
From: tango ward
Date:
Subject: reduce number of multiple values to be inserted
Next
From: tango ward
Date:
Subject: Re: reduce number of multiple values to be inserted