psql

p:: PostgreSQL

psql -h localhost -U prisma -d prisma

How do you find the row count for all your tables in Postgres

SELECT
	nspname AS schemaname,
	relname,
	reltuples
FROM
	pg_class C
	LEFT JOIN pg_namespace N ON (N.oid = C.relnamespace)
WHERE
	nspname NOT IN('pg_catalog', 'information_schema')
	AND relkind = 'r'
ORDER BY
	reltuples DESC;