469,916 Members | 1,896 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,916 developers. It's quick & easy.

Is it possible find a size of a table

Hi All,
Is it possible find the size of a pgsql table.

TIA

--
regards,
Deepa K

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Nov 12 '05 #1
2 1947
you need to install contrib/dbsize. Then you can do:
SELECT relation_size('myTable');
On Thu, 2003-11-20 at 02:30, K. Deepa wrote:
Hi All,
Is it possible find the size of a pgsql table.

TIA


-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.2 (FreeBSD)

iD8DBQA/vMa521dVnhLsBV0RAma9AJsFubohzrpbzNOi0dpNM+9d+d31yQ CePSrO
ot59VyYHZIGPt8Ho5f3Ojzw=
=AAwy
-----END PGP SIGNATURE-----

Nov 12 '05 #2
you need to install contrib/dbsize. Then you can do:
SELECT relation_size('myTable');
On Thu, 2003-11-20 at 02:30, K. Deepa wrote:
Hi All,
Is it possible find the size of a pgsql table.

TIA


-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.2 (FreeBSD)

iD8DBQA/vMa521dVnhLsBV0RAma9AJsFubohzrpbzNOi0dpNM+9d+d31yQ CePSrO
ot59VyYHZIGPt8Ho5f3Ojzw=
=AAwy
-----END PGP SIGNATURE-----

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by K. Deepa | last post: by
3 posts views Thread by Bob Stearns | last post: by
reply views Thread by Salome Sato | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.