SELECT
column_name,
data_type,
character_maximum_length,
is_nullable,
column_default,
is_identity
FROM information_schema.columns
WHERE table_schema = 'ourpension'
AND table_name = 'document_type_for_sign'
ORDER BY ordinal_position;
SELECT *
FROM ourpension.document_type_for_sign
WHERE document_type ILIKE '%Акт%соответствия%'
ORDER BY id;