Re: Add columns to table; insert values based on row

From: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Add columns to table; insert values based on row
Date: 2018-11-02 00:08:32
Message-ID: alpine.LNX.2.20.1811011707360.13759@salmo.appl-ecosys.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, 1 Nov 2018, Rich Shepard wrote:

> I'll use gawk to extract the relevant fields from the text file in which
> they reside (in the correct order), then use emacs keyboard macros to add
> the appropriate update text to each line. Must more efficient (and less
> tedious) than manually writing each line.

Actually a one-liner gawk script does the job.

Thanks again for the suggestion!

Regards,

Rich

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Paquier 2018-11-02 00:17:58 Re: Truncation of UNLOGGED tables upon restart.
Previous Message Stephen Frost 2018-11-01 23:06:32 Re: Truncation of UNLOGGED tables upon restart.