Extract a raster as GeoTIFF from PostGIS 2 ht @bmmeijers

raster.py

import psycopg2

conn_string = "host='' dbname='' user='' password=''"
conn = psycopg2.connect(conn_string)

cursor = conn.cursor()
cursor.execute("SELECT ST_AsTIFF(rast, 'JPEG90') as img FROM sq_rast WHERE rid=1;")
rast = cursor.fetchone()

with open('raster.tiff', 'wb') as f_out:
    f_out.write((rast[0]))

conn.close()