Escape , in table name in export_objects

[SanjeetSingh]

If a table name have a comma in its name, export_objects is not able to fetch the table schema statement.

Got the table statement at schema level like this
select export_objects('','san','false');

CREATE TABLE san.","
(
name varchar(80)
);


But while fetching specific table schema statement comma in name does not work

phjain=> select export_objects('','san.,','false');
ERROR 2569: Catalog object san. does not exist
phjain=> select export_tables('','san.,');
ERROR 2569: Catalog object san. does not exist

I know this is a comma delimited string, but looking for a way to escape comma in table/schema/projection name.

[SanjeetSingh]

Same problem for dot(.) and spaces at start and end of names.
Seems like Vertica is parsing object names list based on using delimiters . and , after trimming.

[JimKnicely]

That must be a bug. The only way to get the table to export us by just specifying the table schema:

Code: Select all

dbadmin=> CREATE SCHEMA san;
CREATE SCHEMA

dbadmin=> CREATE TABLE san.","
dbadmin-> (
dbadmin(>     name varchar(80)
dbadmin(> );
CREATE TABLE

dbadmin=> select export_tables('','san');
                              export_tables
-------------------------------------------------------------------------
 CREATE SCHEMA san;


CREATE TABLE san.","
(
    name varchar(80)
);
(1 row)