Обсуждение: Need help in making the schema name case insensitive.

Поиск
Список
Период
Сортировка

Need help in making the schema name case insensitive.

От
Mayank Gupta - Network
Дата:

Hello Team,

 

We need your assistance in below scenario.

 

Scenario: We have a case sensitive schema name (e.g “Schema_Name”), due to this reason we have to put schema name in double quotes. Now, we have to connect the postgreSQL server via “informatica on cloud”. For the connection from informatica to Postgress we are using JDBC connection.

 

Problem: While connecting to the server via JDBC connection, “Informatica on cloud” do not take case sensitive schema names due to which we are not able to fetchtables from the schema. Could you please suggest any alternative solution that can either give non-case sensitive alias to our case sensitive schema or how to make our schema case insensitive.

 

Note: The existing schema is old schema so we don’t have the option to drop and re-create new schema.

 

Regards,

Mayank

Re: Need help in making the schema name case insensitive.

От
Naveen Kumar
Дата:
No need to drop and create. You can
ALTER SCHEMA name RENAME TO new_name

Regards,

On Dec 7, 2017 4:48 PM, "Mayank Gupta - Network" <gupta_mayank2@network.lilly.com> wrote:

Hello Team,

 

We need your assistance in below scenario.

 

Scenario: We have a case sensitive schema name (e.g “Schema_Name”), due to this reason we have to put schema name in double quotes. Now, we have to connect the postgreSQL server via “informatica on cloud”. For the connection from informatica to Postgress we are using JDBC connection.

 

Problem: While connecting to the server via JDBC connection, “Informatica on cloud” do not take case sensitive schema names due to which we are not able to fetchtables from the schema. Could you please suggest any alternative solution that can either give non-case sensitive alias to our case sensitive schema or how to make our schema case insensitive.

 

Note: The existing schema is old schema so we don’t have the option to drop and re-create new schema.

 

Regards,

Mayank

RE: [EXTERNAL] Re: Need help in making the schema name caseinsensitive.

От
Mayank Gupta - Network
Дата:

Hello Naveen,

 

I already have app in which query are used using old schema name. In case of altering the name of the schema do we need to change the exsisting queries of an app?

 

We can’t change the exsisting queries.

 

Please let me know.

Regards,

Mayank

 

From: Naveen Kumar [mailto:naveenchowdaryon@gmail.com]
Sent: Thursday, December 07, 2017 5:00 PM
To: Mayank Gupta - Network <gupta_mayank2@network.lilly.com>
Cc: pgsql-admin <pgsql-admin@postgresql.org>; Vikram Chaudhary - Network <chaudhary_vikram@network.elanco.com>
Subject: [EXTERNAL] Re: Need help in making the schema name case insensitive.

 

No need to drop and create. You can

ALTER SCHEMA name RENAME TO new_name

 

Regards,

 

On Dec 7, 2017 4:48 PM, "Mayank Gupta - Network" <gupta_mayank2@network.lilly.com> wrote:

Hello Team,

 

We need your assistance in below scenario.

 

Scenario: We have a case sensitive schema name (e.g “Schema_Name”), due to this reason we have to put schema name in double quotes. Now, we have to connect the postgreSQL server via “informatica on cloud”. For the connection from informatica to Postgress we are using JDBC connection.

 

Problem: While connecting to the server via JDBC connection, “Informatica on cloud” do not take case sensitive schema names due to which we are not able to fetchtables from the schema. Could you please suggest any alternative solution that can either give non-case sensitive alias to our case sensitive schema or how to make our schema case insensitive.

 

Note: The existing schema is old schema so we don’t have the option to drop and re-create new schema.

 

Regards,

Mayank