Re: Could not create a table named "USER" under postgreSQL

Ying Lu <ying_lu@cs.concordia.ca> writes:
> I have a table named "USER" under MySQL database. When I am trying to
> move tables from MySQL to PostgreSQL, I found that I could not create a
> table namely "USER". I guess "USER" is a key string used by PostgreSQL
> system so that we could not create a table named "USER". Is that true?

USER is a synonym for CURRENT_USER, as required by the SQL standard
(as far back as SQL92).  So yes, it's a reserved word.  You could
double-quote it if you really want to use it as an identifier.

            regards, tom lane