Column "OID" does not exit

Postgresql 查询表时提示  Column "OID" does not exit

解决方法

1、新建表时带 WITH OIDS 选项

ReportDB=# create table test04 ( a text, b text )  WITH OIDS ;


2、对整个库默认开启OID 

ALTER DATABASE "ReportDB" SET default_with_oids=on;