Subscribe to:
Posts (Atom)
Related Posts
Fatal Error: Peer authentication failed for user "postgres", when trying to get pgsql working with rails.
Problem: Sometimes, we get the following error when trying to make a connection in Rails. FATAL ERROR: Peer authentication failed for us...
-
Sometimes we need to remove special characters from string or columns value. Suppose, we developed an ETL tool that inserting records on ...
-
Many times we come across the scenario where we need to some code based on whether an index exists or not. The following query may he...
-
$cond operator has the keyword "if", "then" and "else", using this operator we can perform if/else in ...
-
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...
-
Many scenarios come in query writing, we have to check particular VIEW exists in the database or not. There are many approaches to che...
-
If you are a DBA and you are working on a data-dictionary for a project so that you can keep track of schema changes and so on, then this ...
-
Here we will discuss the technique to fetch nth row of the table in PostgreSQL. I will use the concept of the LIMIT and OFFSET Clause . ...
-
Problem: Suppose we have a situation where we need to drop those tables that have some prefixes string, so it is possible to drop those ...
-
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 ...