view detailed table schema postgresql
-- All information SELECT * FROM information_schema.columns WHERE table_schema = 'some_schema' AND TABLE_NAME = 'some_table'; -- Or a more simplified version SELECT table_name, column_name, data_type FROM information_schema.columns WHERE table_name = 'some_table';