-
Copying PostgreSQL Database to Another Server
Even it is not a day to day operation for a database administrator database copying is one of the mandatory skills. In this article we will talk about copying PostgreSQL database to another server. TL;DR pg_dump -C -h localhost -U localuser dbname | psql -h remotehost -U remoteuser dbname Dumping SQL pg_dump utility is included…
-
How to Drop All Tables in a PostgreSQL Database?
Today, we will discuss a very dangerous question. How to drop all tables in a PostgreSQL database? This is a very dangerous question, as i see, thats very popular question, i would like to bring it here. The Wrong Way On internet you can find statements like: And grant permissions again. I call this method…