In this post, I am sharing a script for getting the list of objects of a particular User (Owner of the Object) in PostgreSQL. Generally, PostgreSQL DBAs are using this kind of script for auditing purpose and object tracking purpose. Using the below script, you can get the list object for a particular user: I […]
I'm Anvesh Patel, a Database Engineer certified by Oracle and IBM. I'm working as a Database Architect, Database Optimizer, Database Administrator, Database Developer. Providing the best articles and solutions for different problems in the best manner through my blogs is my passion. I have more than six years of experience with various RDBMS products like MSSQL Server, PostgreSQL, MySQL, Greenplum and currently learning and doing research on BIGData and NoSQL technology. -- Hyderabad, India.