Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Database Exporter for Jira - can you create case insensitive tables?

Leo Hart
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
February 16, 2024

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!

0 answers

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
PERMISSIONS LEVEL
Product Admin
TAGS
AUG Leaders

Atlassian Community Events