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]

Re: Is it possible find a size of a table

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:
[color=blue]
> Hi All,
> Is it possible find the size of a pgsql table.
>
> TIA[/color]

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

iD8DBQA/vMa521dVnhLsBV0 RAma9AJsFubohzr pbzNOi0dpNM+9d+ d31yQCePSrO
ot59VyYHZIGPt8H o5f3Ojzw=
=AAwy
-----END PGP SIGNATURE-----

[Franco Bruno Borghesi]

Re: Is it possible find a size of a table

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:
[color=blue]
> Hi All,
> Is it possible find the size of a pgsql table.
>
> TIA[/color]

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

iD8DBQA/vMa521dVnhLsBV0 RAma9AJsFubohzr pbzNOi0dpNM+9d+ d31yQCePSrO
ot59VyYHZIGPt8H o5f3Ojzw=
=AAwy
-----END PGP SIGNATURE-----