Python find out if there is a table?

Question

Python

question - how to correctly find out if there is a table in the database?

Answer 1

from here zetcode.com/db/postgresqlpythontutorial
kind of like an off tutorial

#!/usr/bin/python
# -*- coding: utf-8 -*-

import psycopg2
import sys


con = None

try:
     
    con = psycopg2.connect(database='testdb', user='janbodnar') 
    cur = con.cursor()
    cur.execute('SELECT 1 from mytable')          
    ver = cur.fetchone()
    print ver    //здесь наш код при успехе
    

except psycopg2.DatabaseError, e:
    print 'Error %s' % e    
    sys.exit(1)
    
    
finally:
    
    if con:
        con.close()

Answer 2

you can run a query and, based on its results, find out if there is a table:

SELECT *
FROM pg_tables
WHERE tablename = 'search_table_name'

Answer 3

Look here