On Wed, Dec 21, 2016 at 1:08 AM, David Fetter <da...@fetter.org> wrote: > Would a view that shows only what's to the left of the first semicolon > suit this purpose?
Of course it would, you would just need to make the routines now checking the shape of MD5 and SCRAM identifiers available at SQL level and feed the strings into them. Now I am not sure that it's worth having a new superuser view for that. pg_roles and pg_shadow hide the information about verifiers. -- Michael -- Sent via pgsql-hackers mailing list (email@example.com) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers