View Single Post

   
  #5 (permalink)  
Old 04-09-2008, 06:58 PM
hubert depesz lubaczewski
 
Posts: n/a
Default Re: Some frustrations with admin tasks on PGSQL database

On Fri, Aug 17, 2007 at 09:50:42PM +0800, Phoenix Kiula wrote:
> > How big is the actual table itself (in bytes).

> Where should I find this?


select pg_relation_size('mytable');

depesz

--
quicksil1er: "postgres is excellent, but like any DB it requires a
highly paid DBA. here's my CV!"
http://www.depesz.com/ - blog dla ciebie (i moje CV)

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

Reply With Quote