sureshdsk · November 2, 2021 15:23
diff --git a/pg_lo_example.sql b/pg_lo_example.sql
 # https://www.postgresql.org/docs/14/lo-funcs.html

 INSERT INTO image (name, raster)
    VALUES ('rich_python', lo_import('/Users/dsk/Downloads/rich_python.png'));
    
 SELECT lo_export(image.raster, '/Users/dsk/Downloads/lo_export/rich_python1.png') FROM image
    WHERE name = 'rich_python';
	# https://www.postgresql.org/docs/14/lo-funcs.html

	INSERT INTO image (name, raster)
	VALUES ('rich_python', lo_import('/Users/dsk/Downloads/rich_python.png'));

	SELECT lo_export(image.raster, '/Users/dsk/Downloads/lo_export/rich_python1.png') FROM image
	WHERE name = 'rich_python';