Update: PostgreSQL 9.5 has been released with INSERT .. ON CONFLICT UPDATE support.

PostgreSQL has no "upsert" or "replace" or "insert .. on duplicate key update" or "merge into" construct to conditionally either insert a new row, or if a row with the key already exists, to either update the existing …

SQLAlchemy has a nice reflection facility which takes for example a database table name as argument and produces a Table object out of it for manipulation. However, those objects do not behave like the objects produced by declarative classes, which are easier to work with. Here's a little class that …

Helpful settings for editing tabular data:

setlocal noexpandtab
setlocal nowrap
setlocal tabstop=16 softtabstop=16 shiftwidth=16

Noexpandtab disables expanding of inputted tabs to spaces. Adjust the number of spaces to your liking. Tabstop sets the visual appearance of tab stops (here 16 spaces).

Show tabs visually, disable cursor line …