Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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;

...

WITH (
  OIDS=FALSE
);

ALTER TABLE staging.mytable
OWNER TO postgres;
share|improve this question

1 Answer 1

up vote 1 down vote accepted

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.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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