Python PostgreSQL – Create Database
In this article, we will discuss how to create database in PsotgreSQL using pysopg2 in Python.
CREATE DATABASE is one of the Data Definition Language ( DDL ) statements supported by the PostgreSQL Database Management System. It is used to create database in PostgreSQL. Database name should be always unique. If it already exists then it shows that the particular database already exists.
Attention geek! Strengthen your foundations with the Python Programming Foundation Course and learn the basics.
To begin with, your interview preparations Enhance your Data Structures concepts with the Python DS Course. And to begin with your Machine Learning Journey, join the Machine Learning - Basic Level Course
Syntax: CREATE DATABASE database_name;
Example: Creating Database using Pyscopg2
Python3
import psycopg2 # connection establishmentconn = psycopg2.connect( database="postgres", user='postgres', password='password', host='localhost', port= '5432') conn.autocommit = True # Creating a cursor objectcursor = conn.cursor() # query to create a database sql = ''' CREATE database products '''; # executing above querycursor.execute(sql)print("Database has been created successfully !!"); # Closing the connectionconn.close() |
Output
Database has been created successfully !!
Let’s check the database in PostgreSQL:
