Received: from druid.net (root@druid.net [216.126.72.98]) by hub.org (8.9.3/8.9.3) with ESMTP id IAA68318 for ; Thu, 20 Jan 2000 08:53:36 -0500 (EST) (envelope-from darcy@druid.net) Received: from localhost (1191 bytes) by druid.net via sendmail with P:stdio/R:bind_hosts/T:inet_zone_bind_smtp (sender: ) (ident using unix) id for ; Thu, 20 Jan 2000 08:53:22 -0500 (EST) (Smail-3.2.0.109 1999-Oct-27 #1 built 1999-Dec-25) Message-Id: From: darcy@druid.net (D'Arcy J.M. Cain) Subject: Re: [SQL] crypt in Postgres? In-Reply-To: from Peter Eisentraut at "Jan 20, 2000 12:58:30 pm" To: peter_e@gmx.net (Peter Eisentraut) Date: Thu, 20 Jan 2000 08:53:22 -0500 (EST) Cc: emils@mail.usis.bkc.lv (Emils Klotins), pgsql-sql@postgreSQL.org X-Mailer: ELM [version 2.4ME+ PL54 (25)] MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit 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 | 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.