Start a new topic

@export qualify tables

[This topic is migrated from our old forums. The original author name has been removed]

Hi, trying to export table data I hoped to use something like @export set filename="pathToFile..." sqlqualifier="xyz"; select * from xyz.table; to find in something like insert into xyz.table values (....); instead I always get insert into table values (....); without any qualifier. Is there any way to get qualified table names? Thanks F. Arndt
1 Comment

[This reply is migrated from our old forums.]

Re: @export qualify tables
Hi, What you show in your example should work, assuming you also specify SQL as the format: @export on; @export set filename="/tmp/foo.sql" Format="SQL" sqlqualifier="xyz"; select * from HR.COUNTRIES; @export off; gives INSERT INTO xyz.COUNTRIES (COUNTRY_ID, COUNTRY_NAME, REGION_ID) VALUES ('AR', 'Argentina', 2); ... If this doesn't work for you, please tell us which DbVisualizer version you use and if you use the Free or the Pro edition. Best Regards, Hans