gingerlime

#!/bin/bash

usage()
{
cat << EOF
usage: $0 options

This script set ownership for all table, sequence and views for a given database

Credit: Based on http://stackoverflow.com/a/2686185/305019 by Alex Soto

dansimau

#!/bin/bash
#
# Show replication lag for one or more postgresql slaves in streaming replication.
#
# dsimmons@squiz.co.uk
# 2012-01-09
#

psql="which psql"
psql_extra_opts=""

nesquena

/* How to calculate postgreSQL database size in disk ? */

SELECT pg_size_pretty(pg_database_size('thedbname'));

/* Calculate size of a table including or excluding the index */

SELECT pg_size_pretty(pg_total_relation_size('big_table'));
SELECT pg_size_pretty(pg_relation_size('big_table')); /* without index */

/* See indexes on a table with `\d tablename` */