Re: Another user error? - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Another user error?
Date
Msg-id 5d8a3b24-3829-6d6a-4bb9-dd670624a69e@aklaver.com
Whole thread Raw
In response to Another user error?  (Rich Shepard <rshepard@appl-ecosys.com>)
Responses Re: Another user error?  (Rich Shepard <rshepard@appl-ecosys.com>)
List pgsql-general
On 11/1/20 10:53 AM, Rich Shepard wrote:
> When trying to populate the locations table I get this error:
> psql:locations.sql:2105: ERROR:  syntax error at or near ";"
> LINE 2105: ...E Airport Way',null,'Portland','OR','97218',null,null,null);
>                                                                           ^
> Line 2105 is the last line in the file and is terminated with the only
> semi-colon in the file. Every line prior to this one is terminated with a
> colon. All other syntax errors have been corrected.

I'm hoping that it is:

'Every line prior to this one is terminated with a comma'

not colon.

> 
> I've not encountered this issue before. Where should I look for the error?
> 
> TIA,
> 
> Rich
> 
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com



pgsql-general by date:

Previous
From: Rich Shepard
Date:
Subject: Another user error?
Next
From: Rich Shepard
Date:
Subject: Re: Another user error?