On 8/31/07, Daniel Verite [EMAIL PROTECTED] wrote:
You can get the sizes from pg_largeobject, this way:
SELECT id_doc, sum(length(data)) as filesize
FROM documenti, pg_largeobject
WHERE documenti.file = pg_largeobject.loid
GROUP BY id_doc;
--
Daniel
PostgreSQL-powered mail user agent
Hi all.
I've a table with large objects, here is the definition:
PAFlow-emmebi=# \d documenti
Tabella public.documenti
Colonna | Tipo | Modificatori
-+---+--
id_doc | character varying(50) | not null
file| oid
Marco Bizzarri wrote:
Tabella public.documenti
Colonna | Tipo | Modificatori
-+---+--
id_doc | character varying(50) | not null
file| oid |
kind| integer | not null