<div>
What are the columns in tools.database_acl?<br />
<br />
Say the 'username' column is called 'fred':<br />
delete from tools.database_acl where fred=' username';
</div>


<div>
@<a href="https://www.experts-exchange.com/members/slightwv.html" rel="ugc">slightwv</a>&nbsp; My knowledge of postgres is bad, so I am not sure what is the column in tools.database_acl <br><br>But to verify if The user is still in the database I do :<blockquote>select * from tools.database_acl where db_role = ' <strong>username</strong>';</blockquote><br>To Insert the user into the database I did<blockquote>insert into <strong>tools.database_acl</strong> values ('<strong>db1</strong>',' <strong>username</strong>');</blockquote><br>Is there a possibility to remove the extra space after the quote&nbsp; without deleting the user?
</div>


<div>
It's not really specific to Postgres. &nbsp;Insert, update and delete are basic SQL across all databases.<br />
<br />
&gt;&gt;so I am not sure what is the column in tools.database_acl<br />
<br />
What tool are you using to access Postgres?<br />
<br />
If psql: &nbsp; \d &nbsp;tools.database_acl<br />
<br />
Well, the select uses the column name db_role so, that is a good indicator...<br />
<br />
&gt;&gt;Is there a possibility to remove the extra space after the quote &nbsp;without deleting the user?<br />
<br />
Possibly. &nbsp;The single value in the table is easy:<br />
update tools.database_acl set db_role='username' where db_role=' username';<br />
<br />
Why I say 'possibly', there may be triggers and/or processes that propagate the data from the original insert that might not allow the update because on constraints.<br />
<br />
We'll address that issue if the update fails.
</div>


System Administator

Williams225

<div>
@<a href="https://www.experts-exchange.com/members/slightwv.html" rel="ugc">slightwv</a> it worked!! sorry I didn't apply the command correctly the first time. you are the man!
</div>


<div>
Happy to help.<br />
<br />
To help other people that may have this issue in the future can you deselect my comment <a href="#a43316367" rel="ugc">#a43316367</a>&nbsp;and select the actual comment that worked for you?<br />
<br />
The comments that show they are the actual solution, well, should be the actual solution.
</div>


<div>
<div class="content wysiwyg-content fr-view">
Hello experts,<br>I have made a mistake while creating a user in a postgres db, I added an extra space after the quotation before inserting is username. I wonder what is the correct syntax to remove the user and try to insert again.<br><br>insert into <strong>tools.database_acl</strong> values ('<strong>db1</strong>',' <strong>username</strong>');<br><br>&nbsp;<br><br>
</div>
</div>



Hello experts,
I have made a mistake while creating a user in a postgres db, I added an extra space after the quotation before inserting is username. I wonder what is the correct syntax to remove the user and try to insert again.
insert into
tools.database_acl
values ('
db1
','
username
');
 

How to drop a user from a postgres db

PostgreSQL is an object-relational database management system with an emphasis on extensibility and standards-compliance. As a database server, its primary function is to store data securely, supporting best practices, and to allow for retrieval at the request of other software applications. PostgreSQL implements the majority of the SQL2011 standard, is ACID-compliant and transactional using multiversion concurrency control (MVCC), and handles complex SQL queries using many indexing methods that are not available in other databases. It is cross-platform and runs on many operating systems including Linux, FreeBSD, OS X, Solaris, and Microsoft Windows.