Using the PostgreSQL System Tables

From Jens' Hjørne
Jump to navigation Jump to search

Finding columns and their data types for a specific table

select c.table_name, c.column_name, c.data_type, c.character_maximum_length 
from information_schema.columns as c 
where c.table_name = 'TABLENAME';