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

[Roy Hann]

Mark wrote:

> 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';

Look at column_encrypted, column_encrypted_width, column_encrypt_salt,
and column_encrypt_crc in iicolumns.

Roy