Get the size of a Postgresql table
From time to time, you need to figure out how much data is in a table. This bit of SQL, specific to Postgres, gets you the size of the one that you specify.
SELECT pg_size_pretty(pg_relation_size('your_table'));
-
dictionaryde2 liked this
-
miscarriage8it liked this
-
transientyou83 liked this
-
emileeyou89 liked this
-
verycrispy posted this
Short URL for this post: http://tmblr.co/Zd8FQxEIhZ80