Connect to Redshift but can't use connection

[expired user #10652]'s profile image [expired user #10652] posted 7 years ago in General Permalink

I'm able to use HeidiSQL to connect to a Redshift DB. However, HSQL cannot get any information about the database (Tables/Views/Procedures/etc) ..

It appears that there is an E appended to several of the segments of the initial query

SELECT *, NULL AS data_length, pg_relation_size(QUOTE_IDENT(t.TABLE_SCHEMA) || E'.' || QUOTE_IDENT(t.TABLE_NAME))::bigint AS index_length, c.reltuples, obj_description(c.oid) AS comment FROM "information_schema"."tables" AS t LEFT JOIN "pg_namespace" n ON t.table_schema = n.nspname LEFT JOIN "pg_class" c ON n.oid = c.relnamespace AND c.relname=t.table_name WHERE t."table_schema"=E'<myDBName>';

Does anyone have any insight into this??

Please login to leave a reply, or register at first.