Skip site navigation (1)
Skip section navigation (2)
Schemas
Header And Logo
|
Site Navigation
Schemas
Schema Name
Schema Owner
ACL
information_schema
guillaume
{guillaume=UC/guillaume,=U/guillaume}
pg_catalog
guillaume
{guillaume=UC/guillaume,=U/guillaume}
pg_temp_1
guillaume
pg_toast
guillaume
pg_toast_temp_1
guillaume
public
guillaume
{guillaume=UC/guillaume,postgres=UC/guillaume,=UC/guillaume}
toto
guillaume
SELECT nspname,
pg_get_userbyid(nspowner) AS owner,
nspacl
FROM pg_namespace
ORDER BY nspname
| Schema Name | Schema Owner | ACL |
|---|---|---|
| information_schema | guillaume | {guillaume=UC/guillaume,=U/guillaume} |
| pg_catalog | guillaume | {guillaume=UC/guillaume,=U/guillaume} |
| pg_temp_1 | guillaume | |
| pg_toast | guillaume | |
| pg_toast_temp_1 | guillaume | |
| public | guillaume | {guillaume=UC/guillaume,postgres=UC/guillaume,=UC/guillaume} |
| toto | guillaume |
SELECT nspname, pg_get_userbyid(nspowner) AS owner, nspacl FROM pg_namespace ORDER BY nspname