[This topic is migrated from our old forums. The original author name has been removed]
If in setting/database/PostgreSQL/Qualifier , I check "Export" in the section "Qualify Object with Schema/Database", the export result is wrong.
The name of the schema in the create statement is doubled.
i.e.: (schema nama is oaas)
+CREATE TABLE *"oaas"."oaas".*"device_status" ("id" BIGINT DEFAULT nextval('device_status_id_seq'::regclass) NOT NULL, "name" TEXT NOT NULL, PRIMARY KEY ("id"));+
+INSERT INTO "oaas"."device_status" ("id", "name") VALUES (1, 'NEW');+
As you can see, the insert statement is fine.
Product: DbVisualizer Pro 9.0.6
Build: #1928 (2013/04/14 09:44)
Java VM: Java HotSpot(TM) 64-Bit Server VM
Java Version: 1.6.0_31
Java Vendor: Apple Inc.
OS Name: Mac OS X
OS Arch: x86_64
OS Version: 10.8.3
over 5 years ago
[This reply is migrated from our old forums.]
Re: Schema name export bug
I'm unable to reproduce this problem. Can you please post or email us a screenshot of the Object View Info tab for a table where you see this behavior?