Re: Bulk inserts into two (related) tables

From: Rob Sargent <robjsargent(at)gmail(dot)com>
To: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
Cc: "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Bulk inserts into two (related) tables
Date: 2019-05-22 14:42:58
Message-ID: 4500008F-90D1-4204-BCC6-D0E593DD3A18@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

>
> Each row in the source file (exported from the spreadsheet as .csv and
> renamed to .txt for processing in emacs and awk) is a mixture of attributes
Absolutely no need to rename the .csv for those tools.
> that belong in either or both of the organization and people tables in my
> database. An awk script will extract the appropriate fields for each table.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2019-05-22 14:44:16 Re: Bulk inserts into two (related) tables
Previous Message Adrian Klaver 2019-05-22 14:39:48 Re: distinguish update from insert (on conflict)