assume we have the table with name 'a\b'.
to get info about columns heidi prepared query like this:
SELECT DISTINCT a.attname AS column_name, a.attnum, a.atttypid
, FORMAT_TYPE(a.atttypid, a.atttypmod) AS data_type
, CASE a.attnotnull WHEN false THEN 'YES' ELSE 'NO' END AS IS_NULLABLE
, com.description AS column_comment, def.adsrc AS column_default
, NULL AS character_maximum_length
FROM pg_attribute AS a
JOIN pg_class AS pgc ON pgc.oid = a.attrelid
LEFT JOIN pg_description AS com ON (pgc.oid = com.objoid AND a.attnum = com.objsubid)
LEFT JOIN pg_attrdef AS def ON (a.attrelid = def.adrelid AND a.attnum = def.adnum)
WHERE a.attnum > 0
AND pgc.oid = a.attrelid
AND pg_table_is_visible(pgc.oid)
AND NOT a.attisdropped
AND pgc.relname = 'a\\b' /* <--- problem place */
ORDER BY a.attnum;
the backslash symbol in the literal string 'a\b' has been escaped, therefore the query above returned no result.
can you do something with it?
thank you.
win 7
heidisql 9.2.0.4961
postgresql 9.3.6