Dump PostgreSQL without owner and privileges
$ pg_dump database_name -O -x > output_file
Then you shouldn't see
--
-- Name: public; Type: ACL; Schema: -; Owner: username
--
REVOKE ALL ON SCHEMA public FROM PUBLIC;
REVOKE ALL ON SCHEMA public FROM username;
GRANT ALL ON SCHEMA public TO username;
GRANT ALL ON SCHEMA public TO PUBLIC;
And
--
-- Name: _RETURN; Type: RULE; Schema: public; Owner: username
--
Written by Bartłomiej Danek
Related protips
Have a fresh tip? Share with Coderwall community!
Post
Post a tip
Best
#Postgresql
Authors
Sponsored by #native_company# — Learn More
#native_title#
#native_desc#