missing database from datname

All we need is an easy explanation of the problem, so here it is.

running select datname FROM pg_database gives me a partial list. I’m missing there the db aa.
How is that be? How can I sort it?

all=# \dt aa.*
                List of relations
 schema |   name     | type  | owner
--------+------------+-------+--------
 aa     | aamember   | table | dkuser
 aa     | aaspmember | table | dkuser
 aa     | aamaster   | table | dkuser
(3 rows)

all=#
all=# select datname FROM pg_database;
   datname
--------------
 all
 dev
 padb_harvest
 template1
 template0
(5 rows)

How to solve :

I know you bored from this bug, So we are here to help you! Take a deep breath and look at the explanation of your problem. We have many solutions to this problem, But we recommend you to use the first method because it is tested & true method that will 100% work for you.

Method 1

SVV_TABLE_INFO is the table I was looking for!

Note: Use and implement method 1 because this method fully tested our system.
Thank you 🙂

All methods was sourced from stackoverflow.com or stackexchange.com, is licensed under cc by-sa 2.5, cc by-sa 3.0 and cc by-sa 4.0

Leave a Reply