Python PostgreSQL check database is exist or not














































Python PostgreSQL check database is exist or not




Description:
           We have check database exists or not. In order to that, we have to fetch the list of all the database. After that check database name in list or not.

Python3 program:

import psycopg2

connection = None
try:
    # In PostgreSQL, default username is 'postgres' and password is 'postgres'.
    # And also there is a default database exist named as 'postgres'.
    # Default host is 'localhost' or '127.0.0.1'
    # And default port is '54322'.
    connection = psycopg2.connect("user='postgres' host='localhost' password='postgres' port='5432'")
    print('Database connected.')

except:
    print('Database not connected.')

if connection is not None:
    connection.autocommit = True

    cur = connection.cursor()

    cur.execute("SELECT datname FROM pg_database;")

    list_database = cur.fetchall()

    database_name = input('Enter database name to check exist or not: ')

    if (database_name,) in list_database:
        print("'{}' Database already exist".format(database_name))
    else:
        print("'{}' Database not exist.".format(database_name))
    connection.close()
    print('Done')

Output:
case1:
Database connected. 
Enter database name to check exist or not: postgres 
'postgres' Database already exist 
Done
Case2:
Database connected. 
Enter database name to check exist or not: try 
'try' Database not exist. 
Done

NEXT: Python PostgreSQL create table

More Articles of Dilkhush Kumar:

Name Views Likes
Python Program to Read the Contents of a File 1069 22
Python PostgreSQL insert record into table and get inserted ID 2030 6
Python PostgreSQL prevent SQL injection in DELETE 1149 4
Python PostgreSQL sort the result in ascending order 1464 7
Python Program to Reverse a Stack using Recursion 956 32
Python PostgreSQL where example and usgae 888 6
Python Program to Count the Number of Occurrences of an Element in the Linked List using Recursion 944 26
Python PostgreSQL select particlular column from table 868 7
Python PostgreSQL create table 991 7
Python PostgreSQL 831 4
Python PostgreSQL Order By 830 7
Python Program to Implement Queue 925 15
Python Program to Implement Queue Data Structure using Linked List 1303 29
Python PostgreSQL check database is exist or not 8990 16
Python Program to Create a Linked List & Display the Elements in the List 911 21
Python PostgreSQL limit the no of records in a table 975 7
Python Program to Count the Number of Lines in a Text File 1015 16
Python Program to Implement Bubble Sort 873 17
Python Program to Implement a Stack 974 32
Python Program to Reverse a Stack without using Recursion 1210 35
Python PostgreSQL update existing record 999 7
Python PostgreSQL select from table 1063 6
Python Program to Implement Queues using Stacks 994 23
Python Program to Implement Stack Using Two Queues 1679 27
Python PostgreSQL select with a Filter 2414 6
Python Program to Search for an Element in the Linked List using Recursion 1024 27
Python PostgreSQL insert record into table 961 7
Python PostgreSQL prevent SQL injection in SELECT 1146 4
Python PostgreSQL multiple insert record into table 1029 7
Python PostgreSQL select using fetchone method 962 7
Python Program to Search for an Element in the Linked List without using Recursion 756 22
Python Program to Implement Quicksort 807 21
Python Program to Copy the Contents of One File into Another 2564 14
Python PostgreSQL wildcard select 1344 6
Python PostgreSQL create database 1031 19
Python PostgreSQL sort the result in descending order 1566 7
Python Program to Implement Stack using One Queue 1020 23
Python Program to Count the Number of Occurrences of an Element in the Linked List without using Recursion 1089 18
Python PostgreSQL prevent SQL injection in UPDATE 801 3
Python Program to Append the Contents of One File to Another File 1300 29
Python PostgreSQL join two table 1256 3
Python DB2 connector get started 866 1
Python Program to Find Whether a Number is a Power of Two 753 24
Python PostgreSQL sort the result 837 6
Python Program to Search for a Particular Value in a Binary Tree 909 17
test 876 9
test1 654 4
Python Program to Find the Area of a Triangle Given All Three Sides 826 27
Python Program to Count the Frequency of Words Appearing in a String Using a Dictionary 1000 25
Python Program to Count the Occurrences of a Word in a Text File 1662 24
Python Program to Implement a Stack using Linked List 3255 31
Python PostgreSQL drop table 923 7
Python Program to Find the Length of the Linked List using Recursion 1026 20
Python Program to Display all the Nodes in a Linked List using Recursion 1025 32
Python Program to Find the Length of the Linked List without using Recursion 724 25
Python PostgreSQL delete record from the table 1709 6
Python PostgreSQL drop table only if exists 2263 9
Python PostgreSQL connector get started 935 17
Python Program to Count the Number of Words in a Text File 1494 24
Python Program to Print all the Prime Numbers within a Given Range 785 18
Python Program to Read a File and Capitalize the First Letter of Every Word in the File 1406 22
Python Program to Read a String from the User and Append it into a File 1205 14
Python Program to Implement Merge Sort 912 25

Comments