SELECT table_catalog, table_name, column_name, ordinal_position, column_default, is_nullable, data_type, character_maximum_length, numeric_precision, numeric_scale, datetime_precision FROM information_schema.columns WHERE table_catalog='key_tables' AND table_schema='public' AND table_name='employee' ORDER BY ordinal_position