PostgreSQL special sql 1 - list all the columns and primary

There are a few special sql commands that I used often recently,mark them here.

1: Show all the columns' name

SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME='yourtablename';

another solution

d 'yourtablename'

SELECT               
  pg_attribute.attname,format_type(pg_attribute.atttypid,pg_attribute.atttypmod) 
FROM pg_index,pg_class,pg_attribute 
WHERE 
  pg_class.oid = 'nygeotwitters'::regclass AND
  indrelid = pg_class.oid AND
  pg_attribute.attrelid = pg_class.oid AND 
  pg_attribute.attnum = any(pg_index.indkey)
  AND indisprimary;

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!