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
Marco Bizzarri wrote:
>Tabella "public.documenti"
> Colonna | Tipo | Modificatori
> -+---+--
> id_doc | character varying(50) | not null
> file| oid |
> kind| integer | not nul
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
