Imigration

import psycopg2

path = 'C:/im/'
fields = open(path + 'field.txt', 'w')
con = psycopg2.connect(
    database="dvd",
    user="postgres",
    password="postgres",
    host="127.0.0.1",
    port="5432"
)
cursor = con.cursor()
cursor.execute('SELECT table_name FROM information_schema.tables \
WHERE table_schema NOT IN (\'information_schema\',\'pg_catalog\');')
tables = []
for row in cursor:
    tables += [row[0]]
for row in tables:
    new_file = open(path + row + '.csv', 'w')
    new_file.close()

    cursor.execute('SELECT column_name, data_type \
FROM INFORMATION_SCHEMA.COLUMNS \
WHERE table_name = \'' + row + '\';')
    temp = [row]
    for i in cursor:
        temp += [str(i)]
    fields.write(' '.join(temp) + '\n')

    cursor.execute('COPY (SELECT * FROM "' + row + '") TO \'' + path + row + '.csv\' CSV;')
fields.close()