Re: Add columns to table; insert values based on row - Mailing list pgsql-general

From Rich Shepard
Subject Re: Add columns to table; insert values based on row
Date
Msg-id alpine.LNX.2.20.1811011707360.13759@salmo.appl-ecosys.com
Whole thread Raw
In response to Re: Add columns to table; insert values based on row  (Rich Shepard <rshepard@appl-ecosys.com>)
Responses Re: Add columns to table; insert values based on row
List 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


pgsql-general by date:

Previous
From: Stephen Frost
Date:
Subject: Re: Truncation of UNLOGGED tables upon restart.
Next
From: Michael Paquier
Date:
Subject: Re: Truncation of UNLOGGED tables upon restart.