Skip to content

Instantly share code, notes, and snippets.

# brew
ruby -e "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/master/install)"
# nodejs
brew install node
# bower
npm install -g bower
# python 3
brew install python3
@sureshdsk
sureshdsk / pg_lo_example.sql
Last active November 2, 2021 15:23
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';