row counts

Row Counts of Tables in a SQL Schema and Database:  PostgreSQL vs. YugabyteDB

Row Counts of Tables in a SQL Schema and Database: PostgreSQL vs. YugabyteDB

Getting the total row counts of data in tables across various dimensions (per-table, per-schema, and in a given database) is a useful SQL technique to have in your toolkit. This blog post will guide you to obtain per-table row counts of all tables in PostgreSQL and YugabyteDB. This can serve as a first sanity check after migrating an application with pre-existing data from PostgreSQL to YugabyteDB.

This blog post also outlines how to get the following row counts broken down per table in a schema,

Read more

Explore Distributed SQL and YugabyteDB in Depth

Discover the future of data management.
Learn at Yugabyte University
Get Started Business
Browse Yugabyte Docs
Explore docs Business
PostgreSQL For Cloud Native World
Read for Free Business