[EMAIL PROTECTED] wrote:
Dias Bantekas wrote:
does any one know how to get an md5()-like hash function using
pgcrypto for postgresql 7.3 ? without upgrading to 7.4
Thanks for any input.
SELECT encode(digest(v_password, 'md5'), 'hex');
BTW,
/usr/share/pgsql/contrib/pgcrypto.sql
is the script t
> Dias Bantekas wrote:
>
>> does any one know how to get an md5()-like hash function using
>> pgcrypto for postgresql 7.3 ? without upgrading to 7.4
>>
>> Thanks for any input.
>
> SELECT encode(digest(v_password, 'md5'), 'hex');
BTW,
/usr/share/pgsql/contrib/pgcrypto.sql
is the script that def
Dias Bantekas wrote:
does any one know how to get an md5()-like hash function using pgcrypto
for postgresql 7.3 ? without upgrading to 7.4
Thanks for any input.
SELECT encode(digest(v_password, 'md5'), 'hex');
hlk
---(end of broadcast)---
TIP 8: ex
I think that's what digest does. It doesn't appear to install in 7.4
since 7.4 has the md5 function. I don't have a 7.3 box to test it on
though...
On Tue, 11 May 2004, Dias Bantekas wrote:
> does any one know how to get an md5()-like hash function using pgcrypto
> for postgresql 7.3 ? withou
does any one know how to get an md5()-like hash function using pgcrypto
for postgresql 7.3 ? without upgrading to 7.4
Thanks for any input.
Dias
scott.marlowe wrote:
On Sun, 11 Apr 2004, Jerry McBride wrote:
T. Relyea wrote:
Mike Cox wrote:
Has anyone created something like that for Postgre
I think, that all is about key management. You can store your data with
strong RSA encryption. On server you will have only public key and on
client PC private key.
it's not so easy to use, but it's more secure than symmetrical cipher.
miso
---(end of broadcast)
[EMAIL PROTECTED] ("scott.marlowe") wrote:
> On Mon, 12 Apr 2004, Tom Lane wrote:
>
>> "scott.marlowe" <[EMAIL PROTECTED]> writes:
>> > On Fri, 9 Apr 2004, Christopher Browne wrote:
>> >> See the "pgcrypto" contrib module in the source tree.
>> >>
>> >> It is not typically compiled into what gets
> True, but the original discussion, I believe, was on storing user
> passwords etc... for which md5 is the preferred method...
I thought the original question was what to use for storing credit cards,
for which you want a decryptable method. (A public/private key method
would be even better for
On Mon, 12 Apr 2004, Tom Lane wrote:
> "scott.marlowe" <[EMAIL PROTECTED]> writes:
> > On Fri, 9 Apr 2004, Christopher Browne wrote:
> >> See the "pgcrypto" contrib module in the source tree.
> >>
> >> It is not typically compiled into what gets distributed with the
> >> typical Linux/BSD distrib
"scott.marlowe" <[EMAIL PROTECTED]> writes:
> On Fri, 9 Apr 2004, Christopher Browne wrote:
>> See the "pgcrypto" contrib module in the source tree.
>>
>> It is not typically compiled into what gets distributed with the
>> typical Linux/BSD distribution because of the library dependencies
>> that
> Has anyone created something like that for Postgresql? It would be
> really handy to encrypt credit card numbers and other information so
> it stays secure.
Is there some reason you can't use contrib/pgcrypto? I use it
for storing passwords in an MD5 encryption and credit card data using
encr
In an attempt to throw the authorities off his trail, "T. Relyea" <[EMAIL PROTECTED]>
transmitted:
> MySQL has encryption and decryption functions built in, doesn't Postgresql?
But of course.
See the "pgcrypto" contrib module in the source tree.
It is not typically compiled into what gets distr
Hello,
Actually I would use psql with the \e option. This would allow you to do
what you suggest but also
allow you to stay within psql while you debug your statements. Then when
you are all done and
you have used the appropriate amount of COMMENT ON statements, you can
just do a pg_dump -s
and
Has anyone created something like that for Postgresql? It would be
really handy to encrypt credit card numbers and other information so
it stays secure.
If no one has created anything such as this, I am going to code up
something quite soon, but if it already exists, there is no need for
me to re
14 matches
Mail list logo
