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

Поиск
Список
Период
Сортировка
Искать
От
gnari
Тема
Re: Could not create a table named "USER" under postgreSQL
Дата
Msg-id
001101c48551$82c74880$0100000a@wp2000
Список
Дерево обсуждения
Could not create a table named "USER" under postgreSQL Ying Lu <ying_lu@cs.concordia.ca>
Re: Could not create a table named "USER" under Bill Moran <wmoran@potentialtech.com>
Re: Could not create a table named "USER" under postgreSQL Tom Lane <tgl@sss.pgh.pa.us>
Re: Could not create a table named "USER" under postgreSQL Mike Mascari <mascarm@mascari.com>
"Ying Lu"  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 по дате отправления
От: Andrew Rawnsley
Дата:
Сообщение: Re: Postgresql feature
От: George Essig
Дата:
FAQ