RE: Update "usename" in pg_user
От
Bernd Lentes
Тема
RE: Update "usename" in pg_user
Дата
Msg-id
PR3PR04MB7340875E4F0EE41F263D58D4D6B2A@PR3PR04MB7340.eurprd04.prod.outlook.com
Ответ на
Re: Update "usename" in pg_user (Paul Smith*)
Список
Дерево обсуждения
Update "usename" in pg_user Bernd Lentes <bernd.lentes@helmholtz-muenchen.de>
Re: Update "usename" in pg_user Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: Update "usename" in pg_user "Dischner, Anton" <Anton.Dischner@med.uni-muenchen.de>
Re: Update "usename" in pg_user Ron <ronljohnsonjr@gmail.com>
Re: Update "usename" in pg_user "David G. Johnston" <david.g.johnston@gmail.com>
Re: Update "usename" in pg_user Holger Jakobs <holger@jakobs.com>
Re: Update "usename" in pg_user Paul Smith* <paul@pscs.co.uk>
RE: Update "usename" in pg_user Bernd Lentes <bernd.lentes@helmholtz-muenchen.de>
Re: Update "usename" in pg_user Laurenz Albe <laurenz.albe@cybertec.at>
Re: Update "usename" in pg_user "David G. Johnston" <david.g.johnston@gmail.com>
>> >> update pg_user set usename = 'usename@helmholtz-munich.de' where >> usename = 'dorota.germann'; > >1) don't update system tables directly unless you absolutely must OK. >ALTER USER RENAME TO is what you want > >2) To use characters other than alphanumeric or _ then you need to use >double quotes > > >So: > >ALTER USER dorota.germann RENAME TO "dorota.germann@helmholtz- >munich.de"; > >should do the job > >Paul Hi Paul, thanks. Can I do this for all users in one turn ? Bernd Helmholtz Zentrum München – Deutsches Forschungszentrum für Gesundheit und Umwelt (GmbH) Ingolstädter Landstraße 1, D-85764 Neuherberg, https://www.helmholtz-munich.de Geschäftsführung: Prof. Dr. med. Dr. h.c. Matthias H. Tschöp, Prof. Dr. Dr. h.c. mult. Martin Hrabě de Angelis (komm.) | Aufsichtsratsvorsitzende: MinDir’in Prof. Dr. Veronika von Messling Registergericht: Amtsgericht München HRB 6466 | USt-IdNr. DE 129521671
В списке pgsql-admin по дате отправления
