Skip to content

Instantly share code, notes, and snippets.

@leonardoAlonso

leonardoAlonso/Postgress.sql

Created December 23, 2020 17:32
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save leonardoAlonso/13d392819adad53251b7260812c62ddc to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save leonardoAlonso/13d392819adad53251b7260812c62ddc to your computer and use it in GitHub Desktop.
Download ZIP
Postgres commands
Raw
Postgress.sql
/*Login postgres
sudo -u postgres psql postgres
psql -d odoo // in user with access granted
*/
/*Tamaño de una base de datos */
SELECT pg_database_size('ventas');
/*Tamano de una tabla*/
select pg_table_size('mail_message');
/*Pretty size*/
select pg_size_pretty(pg_table_size('mail_message'));
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment