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.
All the brilliance of AI on minimalist platforms
5 months ago
No comments:
Post a Comment