How to get table total pages count in postgres
To check number of pages do one of SELECT relpages FROM pg_class WHERE relname = 'my_table' ; or explain (analyse, buffers) s...
Showing posts with label PostgreSQL. Show all posts
Showing posts with label PostgreSQL. Show all posts
How to select a schema in postgres CLI when using psql?
In PostgreSQL the system determines which table is meant by following a search path, which is a list of schemas to look in. The first matc...
Subscribe to:
Posts
(
Atom
)
