keyboard shortcuts in psql

there is this quite old, but pretty functional concept: keyboard shortcuts.

you know it – you press ctrl-s, and your editor saves currently-edited file.

my problem is that there are some standard cases when i would really love to have this ability in psql. but psql doesn't support it. or does it?

Continue reading keyboard shortcuts in psql

getting multiple values from sequences

there are this situations where you need (or you think you need) to get multiple values from sequence.

for example – you're importing lots of data: some objects, some objects which relate to base objects, and so on.

of course you can do it all with simple inserts, and currval, but it would be rather slow:

Continue reading getting multiple values from sequences