\dn [ PATTERN ]
The \dn [ PATTERN ]
meta-command returns the schema names and schema owner.
vmartdb=> \dn
List of schemas
Name | Owner
--------------+---------
v_internal | dbadmin
v_catalog | dbadmin
v_monitor | dbadmin
public | dbadmin
store | dbadmin
online_sales | dbadmin
(6 rows)
The following command returns all schemas that begin with the letter v:
=> \dn v*
List of schemas
Name | Owner
------------+---------
v_internal | dbadmin
v_catalog | dbadmin
v_monitor | dbadmin
(3 rows)