Function to export bytea data from database to a directory

From: Terry Khatri <terrykhatri531(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Cc: terrykhatri531(at)gmail(dot)com
Subject: Function to export bytea data from database to a directory
Date: 2014-06-24 15:40:50
Message-ID: CANH4f+jDjcC6rwNPqgoo0qNSHsCdhcOFjaO0VK6EOwDyT4K37Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi
The following function import Images to the database however I wan reverse
of it i.e. taking the image out to a directory, I tried to reverse but can
not get it right, can some be kind enough to do that for me !!
Many thanks
Terry

[code]

create or replace function bytea_import(p_path text, p_result out bytea)
language plpgsql as $$
declare
l_oid oid;
r record;
begin
p_result := '';
select lo_import(p_path) into l_oid;
for r in ( select data
from pg_largeobject
where loid = l_oid
order by pageno ) loop
p_result = p_result || r.data;
end loop;
perform lo_unlink(l_oid);
end;$$;
[/code]

Browse pgsql-admin by date

  From Date Subject
Next Message John Scalia 2014-06-24 18:19:37 Fwd: Re: Wal archive way behind in streaming replication
Previous Message John Scalia 2014-06-23 14:24:14 Wal archive way behind in streaming replication