pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Re: [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