Tuesday, April 5, 2011

Filter the number of databases in pgAdmin

Quick post about reducing the amount of scrolling you have to do in pgAdmin. If you work on a PostgreSQL instance with 124 databases like I do, it helps to be able to filter the list of databases so only the databases you work on show up. This way you don't have to scroll and scan for the DB you want.
To do this:
  1. Right click on the connection to the instance you want to change
  2. Click on Properties
  3. In the "DB restriction" text box add the name of each database you work on single quoted and comma delimited. For example: 'database1','database21','database101'
  4. Restart pgAdmin and you are all set. Now you will only see the databases you work with.