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

[Mark]

On Fri, 5 Dec 2014 13:09:52 +0000 (UTC), Roy Hann
<specially at processed.almost.meat> wrote:

>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.

Thanks. 
-- 
(\__/)  M.
(='.'=) If a man stands in a forest and no woman is around
(")_(") is he still wrong?