Re: reduce number of multiple values to be inserted

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: tango ward <tangoward15(at)gmail(dot)com>
Cc: "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: reduce number of multiple values to be inserted
Date: 2018-05-30 00:21:33
Message-ID: CAKFQuwaTyOocntQF2htrM-GMFCwAsi5osMHTE8XiUDvWDu8giQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tuesday, May 29, 2018, tango ward <tangoward15(at)gmail(dot)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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message tango ward 2018-05-30 00:28:09 Re: reduce number of multiple values to be inserted
Previous Message tango ward 2018-05-30 00:10:05 reduce number of multiple values to be inserted