Re: pg_dump without blobs

["Sébastien Boutté" <sebastien.boutte@xxxxxxxxx>]

I think i've found a solution, i will do this :

CREATE FUNCTION save_bytea_on_system(bytea) RETURNS varchar AS $$
   use File::Temp ();
   $fh = new File::Temp();
   binmode($fh);
   my $data = $_[0];
   $data =~ s{\\(\\|[0-7]{3})}{$1 eq "\\" ? $1 : chr(oct($1))}ge;
   $fname = $fh->filename;
   syswrite $fh,$data;
   close $fh;
   return $fname;	
$$ LANGUAGE plperlu;

update my_table set new_field = lo_import(save_bytea_on_system(old_field));

I think that postgres team should add a method for doing these
conversion much simplier.

Sebastien

On 7/15/07, Sébastien Boutté <sebastien.boutte@xxxxxxxxx> wrote:
> Hi,
>
> I have a postgressql database with a table containing a bytea field. I
> would like to dump without this particulary field in order to improve
> dump and restore time.
> I try with options : -n public (without -b) but it's always the same,
> the dump is huge.
>
> How can i do that ?
> Do i have to convert my field bytea to oid ?
>
> Thank you for your help,
>
> Sebastien