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

Thanks a lot. That is what I am looking for :)

Emi



Dann Corbit wrote:

>According to the current SQL language ANSI/ISO standard, the following
>are reserved words:
>
><reserved word> ::=
>ABS | ALL | ALLOCATE | ALTER | AND | ANY | ARE | ARRAY | AS | ASENSITIVE
>| ASYMMETRIC | AT | ATOMIC | AUTHORIZATION | AVG
>| BEGIN | BETWEEN | BIGINT | BINARY | BLOB | BOOLEAN | BOTH | BY
>| CALL | CALLED | CARDINALITY | CASCADED | CASE | CAST | CEIL | CEILING
>| CHAR | CHAR_LENGTH | CHARACTER | CHARACTER_LENGTH | CHECK | CLOB |
>CLOSE
>| COALESCE | COLLATE | COLLECT | COLUMN | COMMIT | CONDITION | CONNECT
>| CONSTRAINT | CONVERT | CORR | CORRESPONDING | COUNT | COVAR_POP |
>COVAR_SAMP
>| CREATE | CROSS | CUBE | CUME_DIST | CURRENT | CURRENT_DATE
>| CURRENT_DEFAULT_TRANSFORM_GROUP | CURRENT_PATH | CURRENT_ROLE |
>CURRENT_TIME
>| CURRENT_TIMESTAMP | CURRENT_TRANSFORM_GROUP_FOR_TYPE | CURRENT_USER
>| CURSOR | CYCLE
>| DATE | DAY | DEALLOCATE | DEC | DECIMAL | DECLARE | DEFAULT | DELETE
>| DENSE_RANK | DEREF | DESCRIBE | DETERMINISTIC | DISCONNECT | DISTINCT
>| DOUBLE | DROP | DYNAMIC
>| EACH | ELEMENT | ELSE | END | END-EXEC | ESCAPE | EVERY | EXCEPT |
>EXEC
>| EXECUTE | EXISTS | EXP | EXTERNAL | EXTRACT
>| FALSE | FETCH | FILTER | FLOAT | FLOOR | FOR | FOREIGN | FREE | FROM
>| FULL | FUNCTION | FUSION
>| GET | GLOBAL | GRANT | GROUP | GROUPING
>| HAVING | HOLD | HOUR
>| IDENTITY | IN | INDICATOR | INNER | INOUT | INSENSITIVE | INSERT
>| INT | INTEGER | INTERSECT | INTERSECTION | INTERVAL | INTO | IS
>| JOIN
>| LANGUAGE | LARGE | LATERAL | LEADING | LEFT | LIKE | LN | LOCAL
>| LOCALTIME | LOCALTIMESTAMP | LOWER
>| MATCH | MAX | MEMBER | MERGE | METHOD | MIN | MINUTE
>| MOD | MODIFIES | MODULE | MONTH | MULTISET
>| NATIONAL | NATURAL | NCHAR | NCLOB | NEW | NO | NONE | NORMALIZE | NOT
>| NULL | NULLIF | NUMERIC
>| OCTET_LENGTH | OF | OLD | ON | ONLY | OPEN | OR | ORDER | OUT | OUTER
>| OVER | OVERLAPS | OVERLAY
>| PARAMETER | PARTITION | PERCENT_RANK | PERCENTILE_CONT |
>PERCENTILE_DISC
>| POSITION | POWER | PRECISION | PREPARE | PRIMARY | PROCEDURE
>| RANGE | RANK | READS | REAL | RECURSIVE | REF | REFERENCES |
>REFERENCING
>| REGR_AVGX | REGR_AVGY | REGR_COUNT | REGR_INTERCEPT | REGR_R2 |
>REGR_SLOPE
>| REGR_SXX | REGR_SXY | REGR_SYY | RELEASE | RESULT | RETURN | RETURNS
>| REVOKE | RIGHT | ROLLBACK | ROLLUP | ROW | ROW_NUMBER | ROWS
>| SAVEPOINT | SCOPE | SCROLL | SEARCH | SECOND | SELECT | SENSITIVE
>| SESSION_USER | SET | SIMILAR | SMALLINT | SOME | SPECIFIC |
>SPECIFICTYPE
>| SQL | SQLEXCEPTION | SQLSTATE | SQLWARNING | SQRT | START | STATIC
>| STDDEV_POP | STDDEV_SAMP | SUBMULTISET | SUBSTRING | SUM | SYMMETRIC
>| SYSTEM | SYSTEM_USER
>| TABLE | TABLESAMPLE | THEN | TIME | TIMESTAMP | TIMEZONE_HOUR |
>TIMEZONE_MINUTE
>| TO | TRAILING | TRANSLATE | TRANSLATION | TREAT | TRIGGER | TRIM |
>TRUE
>| UESCAPE | UNION | UNIQUE | UNKNOWN | UNNEST | UPDATE | UPPER | USER |
>USING
>| VALUE | VALUES | VAR_POP | VAR_SAMP | VARCHAR | VARYING
>| WHEN | WHENEVER | WHERE | WIDTH_BUCKET | WINDOW | WITH | WITHIN |
>WITHOUT
>| YEAR
>
>
>
>>-----Original Message-----
>>From: pgsql-general-owner@postgresql.org
>>[mailto:pgsql-general-owner@postgresql.org] On Behalf Of Mike Mascari
>>Sent: Wednesday, August 18, 2004 11:24 AM
>>To: Ying Lu
>>Cc: pgsql-general@postgresql.org
>>Subject: Re: [GENERAL] Could not create a table named "USER"
>>under postgreSQL
>>
>>
>>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:
>>
>>[test@lexus] create table user (key integer);
>>ERROR:  syntax error at or near "user" at character 14
>>[test@lexus] create table "user" (key integer); CREATE TABLE
>>[test@lexus] insert into user values (1);
>>ERROR:  syntax error at or near "user" at character 13
>>[test@lexus] insert into "user" values (1);
>>
>>HTH,
>>
>>Mike Mascari
>>
>>
>>---------------------------(end of
>>broadcast)---------------------------
>>TIP 7: don't forget to increase your free space map settings
>>
>>
>>