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: [email protected]
Views: Whole Thread | Raw Message | 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.