Database Reference
In-Depth Information
2
Exploring the
Database
This chapter contains the following recipes:
F
What version is the server?
F
What is the server uptime?
F
Locate the database server files
F
Locate the database server message log
F
Locate the database's system identifier
F
List databases on this database server
F
How many tables in a database?
F
How much disk space does a database use?
F
How much disk space does a table use?
F
Which are my biggest tables?
F
How many rows in a table?
F
Fast estimate of rows in a table
F
Understanding object dependencies
Introduction
To understand PostgreSQL you need to see it in use. An empty database is like a ghost town
without houses.
For now, we're going to assume that you've got a database already. There are already a
1000 topics on how to design your own database from nothing. So here we aim to help the
people who already have access to a PostgreSQL database yet are still learning to use the
PostgreSQL database management system.