Python + PostgreSQL

import psycopg2

conn = psycopg2.connect(

host='scilink.ru', port='5432', database='demo',

user='demo', password='<fpsLfyys[211')

cur = conn.cursor()

cur.execute('SELECT * FROM aircrafts')

rows = cur.fetchall()

for row in rows:

    print(row[0],'\t| ',row[1],'\t| ',row[2])

conn.close()

Пример 2 - запись результата в файл в JSON-формате

import psycopg2

import json

conn = psycopg2.connect(

host='scilink.ru', port='5432', database='demo',

user='demo', password='<fpsLfyys[211')

cur = conn.cursor()

cur.execute('SELECT * FROM aircrafts')

rows = cur.fetchall()

with open('data.txt', 'w') as f:

    json.dump(rows, f)

conn.close()

print('Результат получен, в файл записан!')

with open('data.txt', 'r') as f:  

    Aircrafts = json.load(f)

for row in Aircrafts:

    print(row)

print('Файл прочитан!')