[This topic is migrated from our old forums. The original author name has been removed]
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?
over 4 years ago
[This reply is migrated from our old forums.]
Re: @export qualify tables
What you show in your example should work, assuming you also specify SQL as the format:
@export set filename="/tmp/foo.sql" Format="SQL" sqlqualifier="xyz";
select * from HR.COUNTRIES;
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.