Function to convert from TEXT to BYTEA?
От | D. Dante Lorenso |
---|---|
Тема | Function to convert from TEXT to BYTEA? |
Дата | |
Msg-id | 475F4618.4000409@lorenso.com обсуждение исходный текст |
Ответы |
Re: Function to convert from TEXT to BYTEA?
|
Список | pgsql-general |
All, I want to use the ENCRYPT and DECRYPT functions from contrib, but they require inputs of BYTEA. My data is in VARCHAR and TEXT fields and when I try to use the contrib functions, they complain about wrong datatypes. Is there a string function or something that will take a VARCHAR or TEXT input and output a BYTEA so that I can use that as input for the ENCRYPT/DECRYPT functions? I know about creating a CAST from VARCHAR to BYTEA, but the problem with a CAST is that it doesn't port to other database servers when I do a dump and restore. That forces me to manually have to recreate the cast each time a new database is set up and usually that's the step that gets forgotten. Is there a function that will do what I want to convert the datatype without having to create a CAST that PostgreSQL doesn't have natively? How else are you supposed to use the ENCRYPT and DECRYPT functions? -- Dante
В списке pgsql-general по дате отправления: