PostgreSQL 테이블 헤더 조회

select 
	column_name,
    data_type
from information_schema.columns
where table_name='person' ;


 column_name  |          data_type
--------------+-----------------------------
 id           | bigint
 firstname    | character varying
 lastname     | character varying
 gender       | character varying
 birthday     | timestamp without time zone
 creationdate | timestamp without time zone
 locationip   | character varying
 browserused  | character varying
 email        | character varying
 speaks       | character varying
 id           | graphid
 properties   | jsonb
(12 rows)