PostgreSQL: Setting Up Source User Privileges

To be able to extract DDL of objects in PostgreSQL, all you need to do is to create a new user and assign select privileges on sequences and tables to this user. It will be enough to extract the definitions of the objects required for the migration:

• create a user test_user with a password 'pwd';
• GRANT SELECT ON ALL TABLES IN SCHEMA public TO test_user; –Granting privileges for a schema only applies to this particular schema in the current DB (the current DB at the time of granting).
• GRANT SELECT ON ALL SEQUENCES IN SCHEMA public TO test_user;

If you have any questions, please feel free to contact our support team: support@ispirer.com