We're trying to get the Jira database exporter up and running and we're noticing that the tables it creates in Postgresql are case sensitive. It seems to be creating tables like this:
- CREATE TABLE "TABLE_NAME" (
"COLUMN1" datatype,
"COLUMN2" datatype,
"COLUMN3" datatype,
....
);
vs this:
- CREATE TABLE table_name (
column1 datatype,
column2 datatype,
column3 datatype,
....
);
Case sensitive tables are a bit unusual, requiring you to encapsulate all table/column references with double quotes:
- SELECT "COLUMN1" FROM "TABLE_NAME"
This won't work:
- SELECT column1 FROM table_name
Most prefer to have the following all work via case insensitive tables:
- SELECT column1 FROM table_name
- SELECT COLUMN1 FROM TABLE_NAME
Is there a way to have the tables created in a more traditional, non-case-sensitive, way?
Thanks!