Tag: postgresql
Rename a Postgresql database
#database #postgresqlHere’s the procedure to rename a PostgreSQL database: Disconnect from the database that you want to rename and connect to a different database. Check and terminate all active connections to t... Read more
20 May 2019 - 1 minute readHow to duplicate a Postgresql database
#database #postgresqlIf you need to duplicate an existing Postgresql database, and possibly transfer ownership of the database objects to a new user, here’s how to do that in a quick way: -- First, I recommand getting... Read more
20 Apr 2019 - less than 1 minute readChange default schema on Postgresql
#database #postgresqlIn PostgreSQL, users can have many namespaces to resolve objects names. These are called schemas like in Oracle, and can be altered through the search_path variable. Here’s how to check current sea... Read more
20 Jan 2018 - less than 1 minute readRename all tables in a Postgresql schema
#database #postgresqlAfter a conversion usually done through AWS Database Migration Service, you may have a Postgresql database converted with table names in uppercase. These tables needs renaming, because you can’t ac... Read more
20 Dec 2017 - less than 1 minute readPostgreSQL Survival Guide
#postgresql #databasePostgreSQL has been gaining a lot of popularity these days, so let’s have a look at the basics of administering a PostgreSQL database. We’ll cover the structure exploration, object manipulation and... Read more
20 Jan 2016 - 3 minute read