The following commands are very useful to get some meta-information about the data repository in PostgreSQL. In the psql command line put...
# select datname from pg_database;
to get a list of databases in Postgres in the current repository (e.g. the one pointed by $PGDATA env. variable), ...
#\dt
to get a list of the tables of the current database, and...
#select pg_size_pretty(pg_database_size('DBNAME'));
in order to get the size of the database in user readable format.
Tuesday, April 20, 2010
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment