Ispirer Website
Ispirer Capabilities: PostgreSQL Migration
Free Trial
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