tjwebb / pg-json-schema-export

Export Postgres schemas as JSON ( tables, constraints, sequences)
https://www.npmjs.org/package/pg-json-schema-export
MIT License
38 stars 18 forks source link

Table name in uppercase #7

Closed tiagocandeias closed 4 years ago

tiagocandeias commented 9 years ago

When the schema has table names with first letter in uppercase, an error message appear:

{"name":"error","length":106,"severity":"ERROR","code":"42P01","file":"namespace.c","line":"413","routine":"RangeVarGetRelidExtended"}

Searching for "postgresql 42P01", the conclusion is: Unquoted identifiers are folded to lowercase, so if you created the table with mixed-case letters then you'll have to quote the table name. For more information see "Identifiers and Key Words" in the "SQL Syntax" chapter of the documentation.

http://www.postgresql.org/message-id/20050906045207.GA95353@winnie.fuhr.org