PostgreSQL: Modify OWNER on all tables simultaneously in PostgreSQL

by

You can use the REASSIGN OWNED command.

Synopsis:

REASSIGN OWNED BY old_role [, ...] TO new_role

This changes all objects owned by old_role to the new role. You don’t have to think about what kind of objects that the user has, they will all be changed. Note that it only applies to objects inside a single database. It does not alter the owner of the database itself either.

It is available back to at least 8.2. Their online documentation only goes that far back.

More Related Contents:

  1. How to reset postgres’ primary key sequence when it falls out of sync?
  2. PostgreSQL LIKE query performance variations
  3. How to import CSV file data into a PostgreSQL table
  4. Calculating and saving space in PostgreSQL
  5. The forgotten assignment operator “=” and the commonplace “:=”
  6. Equivalent to unpivot() in PostgreSQL
  7. Passing user id to PostgreSQL triggers
  8. PostgreSQL: ERROR: 42601: a column definition list is required for functions returning “record”
  9. I forgot the password I entered during postgres installation
  10. Do nullable columns occupy additional space in PostgreSQL?
  11. How do I efficiently select the previous non-null value?
  12. How to configure PostgreSQL to accept all incoming connections
  13. Postgresql : Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections [duplicate]
  14. Dynamic SQL (EXECUTE) as condition for IF statement
  15. Disable PostgreSQL foreign key checks for migrations
  16. Prevent recursive trigger in PostgreSQL
  17. serial in postgres is being increased even though I added on conflict do nothing
  18. Can’t connect to Postgresql on port 5432
  19. PostgreSQL Error: Relation already exists
  20. ERROR: permission denied for relation tablename on Postgres while trying a SELECT as a readonly user
  21. How do you create a random string that’s suitable for a session ID in PostgreSQL?
  22. PL/pgSQL functions: How to return a normal table with multiple columns using an execute statement
  23. Update timestamp when row is updated in PostgreSQL
  24. Postgresql query array of objects in JSONB field
  25. Multicolumn index on 3 fields with heterogenous data types
  26. How to add a conditional unique index on PostgreSQL
  27. Select from a table variable
  28. Best way to install hstore on multiple schemas in a Postgres database?
  29. Loop through columns of RECORD
  30. How to drop PostgreSQL database through command line [closed]

Leave a Comment