Databases

To find database size (GB) in Oracle, use below query. select round((sum(bytes)/1048576/1024), 2) from v$datafile;

To take backup and restore in PostgreSQL database, use below commands. Backup : pg_dump -U <userName> -f <backupLocation.sql> <dbName> Restore : psql -d <dbName> -f <backupLocation.sql>