sql查询排除指定字段postgre的查询sql

SELECT

'SELECT ' || array_to_string(ARRAY(

SELECT 'o' || '.' || c.column_name
       FROM information_schema.columns As c
          WHERE table_name = '表名'  AND  c.column_name NOT IN('排除字段', '排除字段')), ',') || ' FROM 表名 As o' As sqlstmt

参考： blog.csdn.net/u011944141/…