gistfile1.txt

  sudo apt-get install postgresql postgresql-client postgresql-contrib libpq-dev postgresql-server-dev-9.1 pgadmin3 -y
 
  sudo -u postgres psql postgres
  CREATE ROLE "ADMIN_NAME" PASSWORD 'qwerty' SUPERUSER CREATEDB CREATEROLE INHERIT LOGIN;
  \q
 
  sudo /etc/init.d/postgresql restart
  psql postgres ADMIN_NAME
 
  SELECT version();
  SELECT datname FROM pg_database;
  \q

$ createuser -s postgres
$ sudo su - postgres
$ psql -U postgres
$ createdb -E UTF8 -O postgres postgres

CREATE OR REPLACE VIEW view_all_grants AS
SELECT
  use.usename as subject,
  nsp.nspname as namespace,
  c.relname as item,
  c.relkind as type,
  use2.usename as owner,
  c.relacl,
  (use2.usename != use.usename and c.relacl::text !~ ('({|,)' || use.usename || '=')) as public
FROM
  pg_user use
  cross join pg_class c
  left join pg_namespace nsp on (c.relnamespace = nsp.oid)
  left join pg_user use2 on (c.relowner = use2.usesysid)
WHERE
  c.relowner = use.usesysid or
  c.relacl::text ~ ('({|,)(|' || use.usename || ')=')
ORDER BY
  subject,
  namespace,
  item
; 

SELECT * FROM view_all_grants WHERE subject = 'rails';

http://www.pontikis.net/blog/postgresql-9-debian-7-wheezy