SELECT
table_name,
column_name,
data_type
FROM information_schema.columns
WHERE table_schema = 'ourpension'
AND table_name IN ('contract', 'contract_params')
AND (
column_name ILIKE '%date%'
OR column_name ILIKE '%creat%'
OR column_name ILIKE '%form%'
OR column_name ILIKE '%reg%'
)
ORDER BY table_name, ordinal_position;