Re: Multi-row insert: error at terminal row. [RESOLVED] - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Multi-row insert: error at terminal row. [RESOLVED]
Date
Msg-id 2654c9b4-ef5e-3760-a258-447fe1e640ca@aklaver.com
Whole thread Raw
In response to Re: Multi-row insert: error at terminal row. [RESOLVED]  (Rich Shepard <rshepard@appl-ecosys.com>)
Responses Re: Multi-row insert: error at terminal row. [RESOLVED]  (Rich Shepard <rshepard@appl-ecosys.com>)
List pgsql-general
On 10/29/20 10:52 AM, Rich Shepard wrote:
> On Thu, 29 Oct 2020, Adrian Klaver wrote:
> 
>> Is orgs-1.sql just the INSERT?
> 
> Yes.

Is it just the 50 line version?

If it is, what happens if you go back to original 1925 line version and 
correct the NULL issue in the line 26 and run it again?

> 
>> How is that file being fed to psql?
> 
> $ psql -d bustrac -f orgs-1.sql
> 
> Rich
> 
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com



pgsql-general by date:

Previous
From: Rich Shepard
Date:
Subject: Re: Multi-row insert: error at terminal row. [RESOLVED]
Next
From: Atul Kumar
Date:
Subject: psql asks for password despite configuring trust authentication