Alter Database in PostgreSQL by Manish Sharma

Key Takeaways

what's up internet I am Manish from rebellionrider.com in this tutorial I will show you how to alter the database using altered database DDR for this purpose I will be using the library database that we created in the previous tutorial and the database management system will remain post Gary SQL so let's get started let's say you want to rename the database from library to new library for that the detail will be to modify the database name begin the statement with the reserve freeze alter database followed by the current name of the database you wish to change which in my case is library then specify the desired action which in this case is rename 2 and provide the new name for the database finally conclude the statement with a semicolon to signify the end of the statement let's execute action done during the creation of the library database we assigned the honor as postgres however suppose we wish to change the owner to HR in that case we can utilize the alter database TDL once again like this again the statement starts with the reserved phrase alter database followed by the database new we wish to modify which in this case is library next we must specify the desired action which is honor 2. finally we need to mention the name of the new owner which is HR let's execute it's done when we initially created the database we designated the default tablespace as TS underscore users in fact I have a tutorial available that details how to create this tablespace which you can access via the link on your screen or in the description however we now wish to switch the default tablespace from TS underscore users to TS underscore HR to accomplish this we will once again employ the alter database statement in the following manner again the statement it starts with the result freeze alter database followed by the name of the database that we want to modify which in my case is library and then we have the action that we want this TDL to perform which in this case is set table space followed by the name of the tablespace that we want to set which is TS underscore HR let's execute it's done these are few of the most common modifications that we as a database administrator have to perform I hope you found this video informative and enjoyable if so please show your support by giving it a thumbs up subscribing to our Channel and hitting the Bell icon thanks for watching this is Manish from rebellionrider.com