(TIL) PSQL: Get The Size Of A Table
With the pg_relation_size() function, we can get the size of a given table. For instance, if we’d like to see the size of the reservations table, we can by e...
Recent Posts
(TIL) PSQL: Dump a database
Using the pg_dump with the -Fc flag will create a dump of the given database in a custom format. The output of this command can be redirected into a file (th...
(TIL) PSQL: Get The Size Of A Database
If you have connect access to a PostgreSQL database, you can use the pg_database_size() function to get the size of a database in bytes.
(TIL) PSQL: Change The Current Directory
When you start a psql session, your current directory is what psql will use as its current directory. This is important for meta-commands that use relative p...
(TIL) PSQL: Auto Expanded Display
By default, postgres has expanded display turned off. This means that results of a query are displayed horizontally. At times, the results of a query can be ...