Postgres: a question of order
Is text created by generated_series always aggregated in numerical order?
PostgreSQL Stan
postgres fanatic
command line aficionado
macOS/darwin (Unix) user
Blog
Recent Posts
Comments on PostgreSQL COMMENT
Take a look at the postgres COMMENT command, a convenient method for documenting database objects.
Learning in public: pgtab
Sample PostgreSQL database for JSON tabular data packages
Self-concatenating table
Probably a terrible idea, but I couldn’t resist trying.
psql: how to paste data into a table
\copy mytable from stdin + paste + \. + enter
Importing multiline JSON objects into PostgreSQL
Summary and examples of what I’ve learned about loading multiline JSON objects into postgres
Loading JSON into Postgres (learning notes)
Lesson: load JSON as binary to avoid (strange) problems with escaped characters
Dig into zsh: How to Function (part 2)
Learn how to configure zsh to load functions from a directory using $fpath and autoload.
Dig into zsh: How to Function (part 1)
A hands-on exploration of writing a shell function in zsh.
Tangled Up in Encoding
Fixing invalid byte sequences in UTF8 text with sed.
Learning how to use Postgres procedures
Personal learning notes