How to hide databases that I am not allowed to access
When I connect to my Heroku - Postgresql database via pgAdmin3, It lists all the tables (about 2600). Every time I open the pgAdmin3 I have to find my own database.
Is there a way to hide databases that I'm not allowed to access ?
Solution
Had the same issue, as its a shared space on AWS with 1000 other DBs.
pgAdmin 3
- Make sure you are disconnected from your server.
- Right click your Server -> properties -> Advanced tab.
- In 'DB restriction' type in the name of your database(s) enclosed in single quotes and separated by spaces. E.g.
'dback447'
pgAdmin 4
Same as above, but on step 3 do not use quotes, just the plain DB name. E.g dback447
pgAdmin 4 version 6.1
Same as above, but press Tab after entering the name of each database. Commas or spaces take your string as a name of one single database.
And you have to press Tab even if you want to type only one database name, otherwise the Save button ignores your changes.
- why my cli give an error when I pushing my app?
- Failed openWeatherMap API call
- Heroku Rails deploy fails with error "could not connect to server: Connection refused"
- Running Django custom manage.py task on Heroku - Importing Issues
- zsh: parse error near `\n' when Adding AWS keys as environment variables
- Connect an Authenticator App with Heroku results in "That code is invalid or expired. Try another."
- Nginx reverse proxy to Heroku fails SSL handshake
- Permission Denied While Running .sh Script in Docker Container with Heroku Dyno Deployed with Github Actions
- IP Address Mismatch on signing into Heroku CLI
- How do I access a private github repo from heroku?
- Migrate PostgreSQL database from Heroku to Railway
- Resource 'corpora/wordnet' not found on Heroku
- Heroku: How to release an existing image in gitlab CI/CD?
- Django Celery Redis
- getting YN0028 The lockfile would have been modified by this install, which is explicitly forbidden. using yarn berry and heroku
- Heroku Nodejs app with R10, H10 and H20 errors
- The argument 'path' must be a string, Uint8Array, or URL without null bytes. Received '\x00@astro-page:astro/assets/endpoint/node' on Heroku deploy
- How to hide databases that I am not allowed to access
- Where do I get a CPU-only version of PyTorch?
- Django email sending on Heroku
- 'matplotlib' has no attribute 'cm' when deploying an app
- Inconsistent ClassCastException for XmlBeans.Factory parse method
- Settings.py cannot find psycopg2... squlite3 and postgresql problem... no such table: auth_user
- Permission problem with heroku stack build locally with docker compose on ubuntu 24.04
- How do I get my heroku app's node version?
- Getting ERR_MODULE_NOT_FOUND in my Heroku App but working fine in localhost
- Heroku/Git: protocol error: bad line length character: erro
- Ruby on Rails App crashing After deployment to Heroku
- How to deploy media files in django-heroku?
- Heroku Stuck on Installing node modules