Skip site navigation (1) Skip section navigation (2)

Query size of large object

From: Alexander Pucher <pucher(at)atlas(dot)gis(dot)univie(dot)ac(dot)at>
To: pgsql-novice <pgsql-novice(at)postgresql(dot)org>
Subject: Query size of large object
Date: 2002-01-31 15:08:11
Message-ID: 3C595DDB.8050309@atlas.gis.univie.ac.at (view raw or flat)
Thread:
Lists: pgsql-novice
Hi,

I have several large object in my DB. Does anybody know how to query the 
size (in Kb or Mb) of these within a SQL statement?

mfg
ALEX

-- 
________________________________________________________

Institut fuer Geographie und Regionalforschung
Universit├Ąt Wien
Kartografie und Geoinformation

Departement of Geography and Regional Research
University of Vienna
Cartography and GIS

Universitaetstr. 7, A-1010 Wien, AUSTRIA

Tel: (+43 1) 4277 48644
Fax: (+43 1) 4277 48649
E-mail: pucher(at)atlas(dot)gis(dot)univie(dot)ac(dot)at

FTP: ftp://ftp.gis.univie.ac.at
WWW: http://www.gis.univie.ac.at/karto
________________________________________________________

"There is a difference between happiness and wisdom: he that thinks himself the happiest man is really so; but he that thinks himself the wisest is generally the greatest fool"-- Francis Bacon
             



pgsql-novice by date

Next:From: Frank BaxDate: 2002-01-31 15:53:47
Subject: Re: column headers all in upper-case letters?
Previous:From: Sammer Reinhard J.Date: 2002-01-31 14:32:09
Subject: Re: column headers all in upper-case letters?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group