Reserved Key Words, Using "path" as a table name
I'm trying to use PostgreSQL as backend database for an existing
windows appl.
The Original MS-SQL DB Uses a table named "path"
Is there a way to create a table in PostgreSQL with the same name.
I read http://www.ca.postgresql.org/users-lounge/docs/7.2/postgres/sql-keywords-appendix.html
but even a
CREATE TABLE "path" (collumn_name int NULL);
complaints with
ERROR: TypeCreate: type path already defined
Is there a way to workaround that.
Thanks
Tom
tom@tom-martin.de (Tom) writes:
CREATE TABLE "path" (collumn_name int NULL);
complaints with
ERROR: TypeCreate: type path already defined
This is not a matter of a reserved word, it's simply that tables have
associated types, and there's already a type named "path".
You could remove or rename the built-in type "path", but a better
solution would be to update to 7.3 so that your table doesn't have
to live in the same namespace as system-defined types.
regards, tom lane