How to download backup PostgreSQL database
How to download backup PostgreSQL database. As we use digital ocean so have to log in to the server with the proper login credentials. So as I have a…
Showing posts with the label Database TutorialShow all
How to restore PostgreSQL database
Today I'm going to share how to restore the PostgreSQL database. First, let me tell you what problem I have solved with it. I was working with so…
Convert Column Type in PostgreSQL
Convert a column to your desired type using the command. Suppose a numeric type column needs to convert to varchar so here it goes. alter table proj…
SQL Subquery
SQL subquery.
Create table in PostgreSQL with foreign key
Create a table in PostgreSQL with a foreign key. Here is how to do that easily. Remember both of the tables contains the primary key. And we need to …
Create Table In PostegreSQL using command
To create a table in PostgreSQL using the command on query tools inside pgadmin write the bellow code. Make sure you change the table name with your…
