Is it possible find a size of a table

[K. Deepa]

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

[Franco Bruno Borghesi]

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-----

[Franco Bruno Borghesi]

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-----