Database Reference
In-Depth Information
> psql -d chapter10
chapter10=# \l
List of
databases
Name | Owner | Encoding |
Collation | Ctype | Access
privileges
-----------+----------+----------+------------+------------+-----------------------
chapter10 | postgres | UTF8 |
en_US.UTF8 | en_US.UTF8 | =Tc/
postgres +
| |
| | | postgres=CTc/
postgres+
| |
| | | group1=Tc/
postgres +
| |
| | | group2=CTc/
postgrespostgres | postgres | UTF8 |
en_US.UTF8 | en_US.UTF8 |
template0 | postgres | UTF8 |
en_US.UTF8 | en_US.UTF8 | =c/
postgres +
| |
| | | postgres=CTc/
postgrestemplate1 | postgres | UTF8 |
en_US.UTF8 | en_US.UTF8 | =c/
postgres +
| |
| | | postgres=CTc/
postgres
4. As you can see,
group1
and
group2
are present in the
Access priv-
ileges
column ofthe
chapter10
database.
group1=Tc/postgres
group2=CTc/postgres
