Re: Fresh eyeballs needed: input into error - Mailing list pgsql-general

Rich Shepard <rshepard@appl-ecosys.com> writes:
> I'm getting a syntax error with an input into statement and I cannot see the
> cause.

> A MWE and the result (N.B.: line one wrapped for readability; it ends with
> 'values'):
> insert into people (person_nbr,lname,fname,job_title,company_nbr,loc_nbr,
> loc_phone_ext,direct_phone,direct_fax,cell_phone,email,active,comment) values
> (6000,'No','Name',null,404,1,null,null,null,null,null,null,null);

> 2: ERROR:  syntax error at end of input
> LINE 2: (
>           ^
> What do I keep missing?

Copying-and-pasting from your mail gets me

ERROR:  relation "people" does not exist
LINE 1: insert into people (person_nbr,lname,fname,job_title,company...
                    ^

so there's nothing wrong with the syntax as-presented.  I agree with
Adrian's guess about invisible characters in your input file;
perhaps a control-D or ASCII NUL would produce that symptom.

            regards, tom lane