How to export data from PostgreSQL table to csv file
We can use COPY statement to export data from PosrgreSQL table to csv file. Step1: Login to PostgreSQL shell Step2:
Read moreWe can use COPY statement to export data from PosrgreSQL table to csv file. Step1: Login to PostgreSQL shell Step2:
Read moreINFO command will show the information and statistics about the redis server. The result includes the total number of keys
Read moreWe can share the AMI with other AWS accounts and this article explains the steps to achieve the same. Step1:
Read moreThis article explains the methods to get the full list of users in Mongodb. We can achieve the same using
Read moreWe can use the following PostgreSQL query to list out the databases. If we requires more detailed information, can use
Read moreSometimes it may required to kill long running queries from MySQL. In-order to do the same, login to the MySQL
Read moreSSH alias will be helpful while dealing with multiple systems as there no need to remember all hostnames/ip addresses. This
Read more