HeidiSQL won't list my database

Question

My postgres yaml part looking like this:

postgres:
    container_name: 'postgres'
    image: postgres:10.1
    environment:
      - POSTGRES_USER=postgres
      - POSTGRES_PASSWORD=root
      - POSTGRES_DB=myids
    ports:
      - "5432:5432"
    networks:
      - app-network

Then when I am logging in with that credentials using HeidiSQL I cant see my database:

Any ideas?

Update thanks to this answer I managed to find my database https://dba.stackexchange.com/a/1304 using this select:

SELECT datname FROM pg_database
WHERE datistemplate = false;

Now the question why HeidiSQL won't show that?

Those are schemas, not databases - those are two very different concepts. With Postgres you connect to **one** database. Once you are connected, you can't switch to a different database. You can only access the schemas _inside_ that database. — , Nov 23 '17 at 11:57
HeidiSQL issues `SELECT nspname FROM pg_catalog.pg_namespace` to retrieve all schemata. And yes, HeidiSQL shows schemata, not databases. That's why the _Databas**e**_ setting in the session manager is not labelled _Databas**es**_ as in MySQL mode. — Anse, Nov 23 '17 at 20:38

score 12 · Accepted Answer · edited Apr 21 '21 at 21:09

12

We have to specify the database name in the connection manager, only then will it display the selected database. Please refer to the images below...

There is no provision to view all the databases in PostgreSQL in HeidiSQL, but for MySQL the database name field is optional.

edited Apr 21 '21 at 21:09

davmos

9,324
4
40
43

answered Sep 06 '18 at 09:55

Cherry g

246
4
14

score 0 · Answer 2 · answered Nov 08 '22 at 14:46

0

Also make sure you don't have the star icon selected. Otherwise it will only show the tables marked as favorites

answered Nov 08 '22 at 14:46

Carlos Arturo

55
8

HeidiSQL won't list my database

2 Answers2