pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedRe: [SQL] crypt in Postgres?
4+ messages / 4 participants
[nested] [flat]
* crypt in Postgres?
@ 2000-01-20 13:47 Emils Klotins <emils@mail.usis.bkc.lv>
2000-01-20 11:58 ` Re: [SQL] crypt in Postgres? Peter Eisentraut <e99re41@DoCS.UU.SE>
0 siblings, 1 reply; 4+ messages in thread
From: Emils Klotins @ 2000-01-20 13:47 UTC (permalink / raw)
To: pgsql-sql
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Hello, I wonder if there is something like crypt() function in
postgtres, which would use standard unix crypt?
TIA!
Emils
-----BEGIN PGP SIGNATURE-----
Version: PGP 6.5.2 -- QDPGP 2.61a
Comment: http://community.wow.net/grt/qdpgp.html
iQA/AwUBOIbZG90sxa1MAPWHEQJYKgCg39FKBZi5zvsJ1XpFL8bPIvuE9HIAoO1+
LrcmsFGeJRi3pdiKmAAFdk1b
=yqsL
-----END PGP SIGNATURE-----
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: [SQL] crypt in Postgres?
2000-01-20 13:47 crypt in Postgres? Emils Klotins <emils@mail.usis.bkc.lv>
@ 2000-01-20 11:58 ` Peter Eisentraut <e99re41@DoCS.UU.SE>
2000-01-20 13:53 ` Re: [SQL] crypt in Postgres? D'Arcy J.M. Cain <darcy@druid.net>
2000-01-20 14:39 ` Re: [SQL] crypt in Postgres? Peter Mount <peter@retep.org.uk>
0 siblings, 2 replies; 4+ messages in thread
From: Peter Eisentraut @ 2000-01-20 11:58 UTC (permalink / raw)
To: Emils Klotins <emils@mail.usis.bkc.lv>; +Cc: pgsql-sql
On Thu, 20 Jan 2000, Emils Klotins wrote:
> Hello, I wonder if there is something like crypt() function in
> postgtres, which would use standard unix crypt?
No, but you can easily write your own. See the chapter on functions in the
programmer's guide.
--
Peter Eisentraut Sernanders vaeg 10:115
peter_e@gmx.net 75262 Uppsala
http://yi.org/peter-e/ Sweden
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: [SQL] crypt in Postgres?
2000-01-20 13:47 crypt in Postgres? Emils Klotins <emils@mail.usis.bkc.lv>
2000-01-20 11:58 ` Re: [SQL] crypt in Postgres? Peter Eisentraut <e99re41@DoCS.UU.SE>
@ 2000-01-20 13:53 ` D'Arcy J.M. Cain <darcy@druid.net>
1 sibling, 0 replies; 4+ messages in thread
From: darcy@druid.net @ 2000-01-20 13:53 UTC (permalink / raw)
To: peter_e@gmx.net; +Cc: emils@mail.usis.bkc.lv; pgsql-sql
Thus spake Peter Eisentraut
> On Thu, 20 Jan 2000, Emils Klotins wrote:
>
> > Hello, I wonder if there is something like crypt() function in
> > postgtres, which would use standard unix crypt?
>
> No, but you can easily write your own. See the chapter on functions in the
> programmer's guide.
In fact, see http://www.druid.net/darcy/files/chkpass.tgz for an example
of a user type that encrypts it's input.
--
D'Arcy J.M. Cain <darcy@{druid|vex}.net> | Democracy is three wolves
http://www.druid.net/darcy/ | and a sheep voting on
+1 416 425 1212 (DoD#0082) (eNTP) | what's for dinner.
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: [SQL] crypt in Postgres?
2000-01-20 13:47 crypt in Postgres? Emils Klotins <emils@mail.usis.bkc.lv>
2000-01-20 11:58 ` Re: [SQL] crypt in Postgres? Peter Eisentraut <e99re41@DoCS.UU.SE>
@ 2000-01-20 14:39 ` Peter Mount <peter@retep.org.uk>
1 sibling, 0 replies; 4+ messages in thread
From: Peter Mount @ 2000-01-20 14:39 UTC (permalink / raw)
To: Peter Eisentraut <peter_e@gmx.net>; +Cc: Emils Klotins <emils@mail.usis.bkc.lv>; pgsql-sql
On Thu, 20 Jan 2000, Peter Eisentraut wrote:
> On Thu, 20 Jan 2000, Emils Klotins wrote:
>
> > Hello, I wonder if there is something like crypt() function in
> > postgtres, which would use standard unix crypt?
>
> No, but you can easily write your own. See the chapter on functions in the
> programmer's guide.
Theres a UnixCrypt class in the JDBC driver which you could use. As its
all static, its easy to translate to another language.
Peter
--
Peter T Mount peter@retep.org.uk
Main Homepage: http://www.retep.org.uk
PostgreSQL JDBC Faq: http://www.retep.org.uk/postgres
Java PDF Generator: http://www.retep.org.uk/pdf
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2000-01-20 14:39 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-01-20 13:47 crypt in Postgres? Emils Klotins <emils@mail.usis.bkc.lv>
2000-01-20 11:58 ` Peter Eisentraut <e99re41@DoCS.UU.SE>
2000-01-20 13:53 ` D'Arcy J.M. Cain <darcy@druid.net>
2000-01-20 14:39 ` Peter Mount <peter@retep.org.uk>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox