개요
- PostgreSQL "DESCRIBE TABLE"
psql
\d+ 테이블명
SQL
SELECT column_name, data_type, character_maximum_length
FROM INFORMATION_SCHEMA.COLUMNS
WHERE table_name = '테이블명';
\d+ 테이블명
SELECT column_name, data_type, character_maximum_length
FROM INFORMATION_SCHEMA.COLUMNS
WHERE table_name = '테이블명';