Re: Could not create a table named "USER" under postgreSQL - Mailing list pgsql-general

From gnari
Subject Re: Could not create a table named "USER" under postgreSQL
Date
Msg-id 001101c48551$82c74880$0100000a@wp2000
Whole thread Raw
In response to Could not create a table named "USER" under postgreSQL  (Ying Lu <ying_lu@cs.concordia.ca>)
List pgsql-general
"Ying Lu" <ying_lu@cs.concordia.ca> did write:


> Hello,
>
> 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?

ironically, you actually can create a table named "USER", but
not a table named USER

gnari=# create table "USER" (foo varchar);
CREATE TABLE


gnari




pgsql-general by date:

Previous
From: Andrew Rawnsley
Date:
Subject: Re: Postgresql feature
Next
From: George Essig
Date:
Subject: Re: Installing FullTextSearchTool tsearch2