SELECT * FROM pg_attribute WHERE attrelid = ‘tablename’::regclass; –只查看字段名 SELECT attname FROM pg_attribute WHERE attrelid = ‘tablename’::regclass;