[Info-ingres] How to see if a column is encrypted from the system catalogs

Mark i at dontgetlotsofspamanymore.invalid
Fri Dec 5 13:02:48 UTC 2014


We query the ii* tables (iitables, iicolumns etc) to find out about
extant tables.  How can we determine if a column is encypted. For
example:

CREATE TABLE socsectab
(
  fname CHAR(10),
  lname CHAR(20),
  socsec CHAR(11) ENCRYPT NOSALT
)
WITH ENCRYPTION=AES128,
PASSPHRASE='this is a secret';
-- 
(\__/)  M.
(='.'=) If a man stands in a forest and no woman is around
(")_(") is he still wrong?




More information about the Info-ingres mailing list