Thread: Reserved Key Words, Using "path" as a table name

Reserved Key Words, Using "path" as a table name

From
tom@tom-martin.de (Tom)
Date:
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


Re: Reserved Key Words, Using "path" as a table name

From
Tom Lane
Date:
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