Ying Lu wrote:
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?
You'll have to quote it in all the SQL you use if you insist on using it:
[EMAIL PROTECTED] create table user (key integer); ERROR: syntax error at or near "user" at character 14 [EMAIL PROTECTED] create table "user" (key integer); CREATE TABLE [EMAIL PROTECTED] insert into user values (1); ERROR: syntax error at or near "user" at character 13 [EMAIL PROTECTED] insert into "user" values (1);
HTH,
Mike Mascari
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
