On 04/23/2014 08:14 AM, Kalai R wrote:
I have used custom format archieve in pg_dump. I have used the following command in plpgsql function to insert the image. lo_import(xlogopath) After I inserted one image more records are created in pg_largeobject and pg_largeobject_metadata tables other than the OID returned from lo_import
Large objects are stored in pg_largeobject in chunks, so this is not surprising. See below for more detail:
http://www.postgresql.org/docs/current/static/catalog-pg-largeobject.html -- Adrian Klaver adrian.klaver@xxxxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
