Why does pgAdmin3 automatically set the table owner to postgres when its created and set OIDS=FALSE? I am new to PostgreSQL and want to know the rational behind this default behavior.

-- Table: staging.mytable

-- DROP TABLE staging.mytable;



ALTER TABLE staging.mytable
OWNER TO postgres;

1 Why oids=false?

OIDS=FALSE/TURE, the default setting depends upon the default_with_oids configuration parameter,The parameter is off by default。in PostgreSQL 8.0 and earlier, it was on by default.

2 Why ownered by postgres?

Please check the role you use log in when using pgAdmin3 , if you log in as postgres role ,then the owner of new created table will be the postgres role.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.