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

From: "gnari" <gnari(at)simnet(dot)is>
To: "Ying Lu" <ying_lu(at)cs(dot)concordia(dot)ca>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: Could not create a table named "USER" under postgreSQL
Date: 2004-08-18 18:31:00
Message-ID: 001101c48551$82c74880$0100000a@wp2000
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Ying Lu" <ying_lu(at)cs(dot)concordia(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message George Essig 2004-08-18 18:34:16 Re: Installing FullTextSearchTool tsearch2
Previous Message Andrew Rawnsley 2004-08-18 18:29:03 Re: Postgresql feature