Maintenance, Optimization, and Performance Tuning - PostGIS - page 586

List of
databases
Name | Owner | Encoding |
Collate | Ctype | Access
privileges
-----------+----------+----------+------------+------------+-----------------------
postgres | 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
test | postgres | UTF8 |
en_US.utf8 | en_US.utf8 |
19. Connecttothe test databaseandgetthelistoftablesbyexecutingthefol-
lowing commands:
postgres=# \c test
test=# \d
List of relations
Schema | Name | Type | Owner
--------+------+-------+----------
public | test | table | postgres
20. Get the records, if any, in the test table by executing the following com-
mands:
test=# SELECT * FROM test;