August 2, 2021 | TECHIES WORLD

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:

INFO command will show the information and statistics about the redis server. The result includes the total number of keys

We can share the AMI with other AWS accounts and this article explains the steps to achieve the same. Step1:

This article explains the methods to get the full list of users in Mongodb. We can achieve the same using

We can use the following PostgreSQL query to list out the databases. If we requires more detailed information, can use

Sometimes it may required to kill long running queries from MySQL. In-order to do the same, login to the MySQL

SSH alias will be helpful while dealing with multiple systems as there no need to remember all hostnames/ip addresses. This

Cookie	Duration	Description
cookielawinfo-checkbox-analytics	11 months	This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Analytics".
cookielawinfo-checkbox-functional	11 months	The cookie is set by GDPR cookie consent to record the user consent for the cookies in the category "Functional".
cookielawinfo-checkbox-necessary	11 months	This cookie is set by GDPR Cookie Consent plugin. The cookies is used to store the user consent for the cookies in the category "Necessary".
cookielawinfo-checkbox-others	11 months	This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Other.
cookielawinfo-checkbox-performance	11 months	This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Performance".
viewed_cookie_policy	11 months	The cookie is set by the GDPR Cookie Consent plugin and is used to store whether or not user has consented to the use of cookies. It does not store any personal data.