[GENERAL] How do you find the row count for all your tables in Postgres?

Hi How can we find the total row count for all db tables in psql version 7.4.3 ?? The query which worked fine in psql 9.2 version is : SELECT schemaname,relname,n_live_tup FROM pg_stat_user_tables ORDER BY n_live_tup DESC. But same query throws error as 'ERROR: column "n_live_tup" does not exis

[GENERAL] PSQL log file

Hi Is there any option in psql version 9.2.4, to insert the date time also inside the psql log files(in path /var/log/postgresql) ? -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] To monitor the number of PostgreSQL database connections?

Hi Could you please provide any method (query or any logfile) to check max connections happened during a time interval in psql DB ? -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general