PostgreSQL.get_database_size
- PostgreSQL.get_database_size(database_name=None)
Get the size of a database.
- Parameters
database_name (str or None) – name of a database; if
database_name=None
(default), the function returns the size of the currently-connected database- Returns
size of the database
- Return type
int
Examples:
>>> from pyhelpers.dbms import PostgreSQL >>> testdb = PostgreSQL('localhost', 5432, 'postgres', database_name='testdb') Password (postgres@localhost:5432): *** Creating a database: "testdb" ... Done. Connecting postgres:***@localhost:5432/testdb ... Successfully. >>> testdb.get_database_size() '8553 kB' >>> testdb.DEFAULT_DATABASE 'postgres' >>> testdb.get_database_size(database_name=testdb.DEFAULT_DATABASE) '8609 kB' >>> testdb.drop_database(verbose=True) # Delete the database "testdb" To drop the database "testdb" from postgres:***@localhost:5432 ? [No]|Yes: yes Dropping "testdb" ... Done.