Use below command to get only table data from a PostgreSQL table. It will not dump table create structure.
Tag: postgresql
kill a running query in postgres
There are queries which takes more times to execute. Sometimes you need to stop the queries but you can’t do it simply(Ctrl+c) because queries are
Disable an index in postgres
If you have got one index on a table that you would like to temporarily disable you can do following steps. You can poke the
PostgreSQL Indexes
There are many types of indexes in Postgres, as well as different ways to use them. In this article we give an overview of the
