Problem with DROP ROLE

Поиск
Список
Период
Сортировка
От Brice André
Тема Problem with DROP ROLE
Дата
Msg-id CAOBG12mCa-07QW==228ieiosV_TKWK8wAowAhW+kXSkyVkfY9Q@mail.gmail.com
обсуждение исходный текст
Ответы Re: Problem with DROP ROLE
Re: Problem with DROP ROLE
Список pgsql-sql
Hello everyone,<br /><br />I would want to implement an SQL query where I would be able to suppress all information
froma registered user. I am currenlty able to suppress everything except the user role. The name of the role is present
ina table and so, I would want to perform something like this : <br /> DROP ROLE (SELECT ...)<br />but this is not
consideredas valid, as DROP ROLE is expecting a name and not a text field. So, I tried the following, but with no
success: <br />DROP ROLE CAST((SELECT...) AS name)<br /><br />So, does someone knows how to handle this problem ?<br
/><br/>Regards,<br />Brice<br /> 

В списке pgsql-sql по дате отправления:

Предыдущее
От: Basil Bourque
Дата:
Сообщение: Re: new user on mac
Следующее
От: Guillaume Lelarge
Дата:
Сообщение: Re: Problem with DROP ROLE