Get the Size of a Postgres Table’s Indexes
Here’s how to get the size of any PostgreSQL table’s indexes, as stored on disk. We show how to get the size of a table’s indexes in an human-readable form like “2 MB”. We also show to easily get a table’s … Continue reading
Filed in Indexes
Leave a comment
Get the Size of a Postgres Table
Here’s how to get the size of any PostgreSQL table, as stored on disk. We show how to get the table’s size in an human-readable form like “5 MB”. We also show to get a table’s size as just a raw … Continue reading
Filed in Tables
Leave a comment
psql
psql is PostgreSQL’s command-line tool for working with Postgres databases. psql is always included with PostgreSQL database software installations, so if you’re working with Postgres, it’s very handy to know how to use it. These commands were tested with Postgres … Continue reading
Filed in Tools
Leave a comment
Postgres SQL Tools
Common tools for working in SQL with Postgres are: psql – A command-line tool for access to PostgreSQL. psql is always installed with Postgres. pgAdmin – A graphical administration tool for Postgres, with versions for Mac, Linux and Windows. phpPgAdmin … Continue reading
Filed in Tools
Leave a comment