On 8/31/07, Daniel Verite <daniel@xxxxxxxxxxxxxxxx> 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 and storage: http://www.manitou-mail.org > Thanks a lot for the suggestion: I didn't think to use the pg_largeobject: much cleaner, now :-) Regards Marco -- Marco Bizzarri http://iliveinpisa.blogspot.com/ ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org/
