On 2019-01-15 12:56:05 +0100, Daniel Verite wrote:
> Mihalidesová Jana wrote:
> > nipjd=> select distinct encode(serializable_value, 'escape') from
> > alf_node_properties_zaloha where serializable_value is not null;
> >
út 15. 1. 2019 v 12:56 odesílatel Daniel Verite
napsal:
> Mihalidesová Jana wrote:
>
> > nipjd=> select distinct encode(serializable_value, 'escape') from
> > alf_node_properties_zaloha where serializable_value is not null;
> >
>encode
> >
> ---
Mihalidesová Jana wrote:
> nipjd=> select distinct encode(serializable_value, 'escape') from
> alf_node_properties_zaloha where serializable_value is not null;
>
> encode
> ---
> nipjd=> select distinct encode(serializable_value, 'escape') from
> alf_node_properties_zaloha where serializable_value is not null;
>
>
> encode
>
>
> -
hex')
>>
>> decode(E'aced00057e72002c6f72672e616c66726573636f2e736572766963652e636d722e76657273696f6e2e56657273696f6e54797065127872000e6a6176612e6c616e672e456e756d1278707400054d414a4f52',
>> 'hex')
>>
>>
3636f2e736572766963652e636d722e76657273696f6e2e56657273696f6e54797065127872000e6a6176612e6c616e672e456e756d1278707400054d414a4f52',
> 'hex')
>
> (6 rows)
>
>
>
> So, how I convert bytea to text?
>
I use a function - when enco
d414a4f52',
'hex')
(6 rows)
So, how I convert bytea to text?
Thanks,
JM
From: Pavel Stehule
Sent: Tuesday, January 15, 2019 9:46 AM
To: Mihalidesová Jana
Cc: pgsql-general@lists.postgresql.org
Subject: Re: Oracke BLOB to Postgres BYTEA using ora2pg
Hi
út 15. 1. 2019 v 9:40
Dobro jutro
On 15/1/19 10:39 π.μ., Mihalidesová Jana wrote:
Hi,
We try to migrate from oracle to postgres using ora2pg but we hit some weird
behavior of bytea. Or it’s just our ignorance.
Table migration were ok, but we are not able to read bytea data. What we did
wrong.
Assuming your da
Hi
út 15. 1. 2019 v 9:40 odesílatel Mihalidesová Jana <
jana.mihalides...@cetin.cz> napsal:
> Hi,
>
>
>
> We try to migrate from oracle to postgres using ora2pg but we hit some
> weird behavior of bytea. Or it’s just our ignorance.
>
> Table migration were ok, but we are not able to read bytea da
