Redshift

datname 中缺少數據庫

  • May 11, 2021

runningselect datname FROM pg_database給了我一個部分列表。我在那裡想念 db aa。那是怎麼回事?我該如何排序?

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)

SVV_TABLE_INFO是我要找的桌子!

引用自:https://dba.stackexchange.com/questions/291311