Postgres Pro
Downloads
Home   >   mailing lists

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

From Devrim Gündüz
Subject Re: [BUGS] Creating a table by loading a sql file.
Date
Msg-id 1509092292.24698.1.camel@gunduz.org
Whole thread Raw
In response to [BUGS] Creating a table by loading a sql file.  (rhodesm4 <rhodesm4@msu.edu>)
Responses Re: [BUGS] Creating a table by loading a sql file.  (Oleksandr Shulgin <oleksandr.shulgin@zalando.de>)
List pgsql-bugs
Tree view 
Hi,

On Fri, 2017-10-27 at 04:55 +0000, rhodesm4 wrote:
> psql:users.sql:10: ERROR:  syntax error at or near "USER"
> LINE 1: CREATE TABLE USER(

USER is a reserved keyword in PostgreSQL:

https://www.postgresql.org/docs/current/static/sql-keywords-appendix.html

You need to change the table name.

Regards,
--
Devrim Gündüz
EnterpriseDB: https://www.enterprisedb.com
PostgreSQL Consultant, Red Hat Certified Engineer
Twitter: @DevrimGunduz , @DevrimGunduzTR

pgsql-bugs by date:

Previous
From: rhodesm4
Date:
Subject: [BUGS] Creating a table by loading a sql file.
Next
From: "joan_he@189.cn"
Date:
Subject: [BUGS] Parameters bgwriter_lru_maxpages Comment error？