I usually write about PostgreSQL, but lately someone asked for help, and one of the problems was similar to sudo command from title. This was not the first time I saw it, so figured, I'll write a blogpost about it, just ...

On 27th of February, Heikki Linnakangas committed patch: Add support for piping COPY to/from an external program. This includes backend "COPY TO/FROM PROGRAM '...'" syntax, and corresponding psql \copy syntax. Like with reading/writing files, the backend version is superuser-only, and in the psql version, ...

September 17th, 2012 by depesz | Tags: , , , , , , | 1 comment »

For those of you that don't know - Tmux is program similar to screen, but written from scratch, with different functionality, approach, and capabilities. I would like to show one particular case where I found that Tmux does something that screen ...

(disclaimer: all the data and examples in here are on Linux - the same data can be probably obtained on other systems too, it's just that I work on Linux and don't know other systems well). This question pops occasionally in ...

I'm quite often doing stuff on remote machines, and quite frequently I start some long-running job, when I remember that I didn't ran it via screen - so it will break, if my network connection will die. Is there any sane ...

March 12th, 2009 by depesz | Tags: , , , , , , | 6 comments »

I had this interesting case at work. We have imports of objects. Each object in import file has its "ID" (which can be any string). Same "ID" is in database. So the idea is pretty simple - we can/should check how ...

This post will probably be boring for you, but this is mostly just a reminder to myself, written in form of a blog post. So, I have a directory structure: /some/path/imported/DATE/TIME/file, where DATE is date of importing, in format YYYY-MM-DD, and ...