[BUGS] Creating a table by loading a sql file. - Mailing list pgsql-bugs

From rhodesm4
Subject [BUGS] Creating a table by loading a sql file.
Date
Msg-id DM3PR1201MB1119B73EFEF09A29F7510484955A0@DM3PR1201MB1119.namprd12.prod.outlook.com
Whole thread Raw
Responses Re: [BUGS] Creating a table by loading a sql file.  (Devrim Gündüz <devrim@gunduz.org>)
List pgsql-bugs

So I have this SQL code:



\c mydb;

CREATE TABLE USER(
   ID INT PRIMARY KEY     NOT NULL,
   NAME           TEXT    NOT NULL,
   EMAIL          TEXT    NOT NULL,
   PASSWORD       TEXT   NOT NULL,
);




INSERT INTO USER (name, email, password)
  VALUES ('Tyler', 'tylerrobinson@whatver.com', 'tyler');

And I keep getting these errors:


WARNING: Console code page (437) differs from Windows code page (1252)
         8-bit characters might not work correctly. See psql reference
         page "Notes for Windows users" for details.
psql:users.sql:10: ERROR:  syntax error at or near "USER"
LINE 1: CREATE TABLE USER(
                     ^
psql:users.sql:16: ERROR:  syntax error at or near "USER"
LINE 1: INSERT INTO USER (name, email, password)
                                     ^

pgsql-bugs by date:

Previous
From: Amit Langote
Date:
Subject: Re: [BUGS] BUG #14873: table_constraint description missing in ALTERTABLE synopsis
Next
From: Devrim Gündüz
Date:
Subject: Re: [BUGS] Creating a table by loading a sql file.