Postgres - dotted schema name

Question

Hi All,

I have a strange schema name to work with in postgres "apac.logistics@vivn.com". The table name is "TableName"

I am trying to load data from an excel file by creating the above table using Postgres Bulk loader and it fails with the below error.

Error: Output Data (9): Error creating table "apac.logistics@vivn.com.TableName": ERROR: improper qualified name (too many dotted names): apac.logistics@vivn.com.TableName;
Error while executing the query
CREATE TABLE "apac"."logistics@vivn"."com"."TableName" ("Level 1" varchar(255),"Level 2" varchar(255),"Level 3" varchar(255))

Any help on getting this working even though the issue is with the bad schema naming I have no access to change the schema name and is in use by other project teams.

I have tried the following while specifying the conection string but none work

apac.logistics@vivn.com.TableName

"apac.logistics@vivn.com.TableName"

"apac.logistics@vivn.com"."TableName"

Please advise on how I can fix this and proceed with the data load on table creation

Thanks

TrevorS · Answer

Hello @JDong

I searched your error and found the below response:
On further researching, I was able to find that this was a known issue in Aurora Version 2.0 (compatible with 10.4) and the issue has been fixed on Aurora Version 2.1 ( compatible with PostgreSQL 10.5). I tried testing on my Aurora PostgreSQL 10.5 test cluster to confirm if the issue has been fixed and I was able to successfully execute the statement without any error message.

If possible, can you share a copy of your workflow as well? This will help to troubleshoot based on what tools you are using, and what tools are encountering this error message.

Thanks,

TrevorS