On Fri, Jul 14, 2006 at 03:21:01PM +0400, Eugene Prokopiev wrote:
> Hi,
>
> Is it possible to read cleartext user password from pgsql database? In
> this link
> http://www.postgresql.org/docs/8.1/interactive/view-pg-user.html
> explained that password always reads as ********. But I need to use
> pgsql login/password as authentication info for another service.
You can't get back the cleartext password, it's hashed.
To see the hashed password you need to bypass the view, see pg_shadow.
The docs should say something about how the hash is calcualted.
Hope this helps,
--
Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.