2 ms·

I can't say that I've actually used any of those. You can do the same with CREATE [USER|SCHEMA|DATABASE] quite happily and ignore the rest. I tend not to use t

by csmuk 13y ago

I can't say that I've actually used any of those. You can do the same with CREATE [USER|SCHEMA|DATABASE] quite happily and ignore the rest. I tend not to use the CLI though as anything that presents a readline interface is a POS to work with when you have a verbose statement to type in. I'll type it out in VIM then throw the buffer through psql. I wouldn't run anything on OSX bar some Cocoa apps myself. Same with Windows. Everything Unixy happens inside a virtual machine. I don't care if OSX is Unix certified or Windows has cygwin - they're both a pain to deal with on a daily basis.

pselbert 13y ago
Using \e within the psql shell will drop you right into your $EDITOR, which is likely vim. You can edit commands in there directly and they will be evaluated when you :wq out. The next time you type \e it will load the previous command back into the editor My only issue with this workflow is when I want to yank the command out to the clipboard. For some reason it doesn't seem to respect clipboard settings on OS X.