PostgreSQL: How to change the password of the user
This article will teach you to change the password of the user in PostgreSQL. To change the password, we use the ALTER ROLE, its uses are ...
-
Sometimes we need to remove special characters from string or columns value. Suppose, we developed an ETL tool that inserting records on ...
-
Many scenarios come in query writing, we have to check particular VIEW exists in the database or not. There are many approaches to che...
-
This issue comes much time when we are using PostgreSQL with Node.js, Error: Cannot find module 'bcrypt' in nodejs application, and...
-
Problem: DBA work is critical and sensitive; we work on Non Relational or Relational Database and the data consistency is a common facto...
-
We can use $add an operator to add days in ISODate in MongoDB, $add is the Arithmetic Aggregation Operator, which adds number and date in ...
-
Problem: Suppose you are creating an application using Java and for the backend you are using PostgreSQL, sometimes we face the error as... -
Problem: Suppose we have a collection and one field is type string contains some special character (like !@#$%) and we don’t want these s...
-
We can use $subtract operator to subtract tow numbers. $subtract is arithmetic aggregation operator which subtract two number and returns ...
-
Problem: I want to drop my table, but I am not able to drop the table while I tried the query "DROP TABLE MyTable CASCADE;". ...
-
Problem: I need to clone production database to the testing purpose, mean I want to create the copy of the production database, so what ...