Use the psql meta-command \d+ psql -h myserver.mydomain.com -U music musicdb music=> \d+ List of relations Schema | Name | Type | Owner | Size | Description ----------------+--------------------------------+----------+----------------+------------+------------- public | pg_stat_statements | view | postgres | 0 bytes | music | music_seq1 | sequence | music | 8192 bytes | music | music_seq2 | sequence | music | 8192 bytes | music | table1 | table | music | 16 kB | music | music_seq3 | sequence | music | 8192 bytes | music | table2 | table | music | 3723 MB | music | table3 | sequence | music | 8192 bytes | music | table4 | table | music | 0 bytes | music | table5 | table | music | 6117 MB | music | table6 | table | music | 1884 MB | music | table7 | table | music | 8192 bytes | (24 rows)
If you only want to view the tables, use "\dt" instead of "\d+"
A good source for other size-related queries is this tutorial
No comments:
Post a Comment