I'm largely new to PostgreSQL and it is quite possible that I'm using it all wrong, sorry for ranting.
I'm largely new to PostgreSQL and it is quite possible that I'm using it all wrong, sorry for ranting.
Also, dropdb, createdb, postgres, pg_ctl, initdb, pg_basebackup. No consistency.
EDIT: There was a discussion and a patch 5 years ago, but I am not sure what was the final result other than that it was obviously not changed.
http://www.postgresql.org/message-id/47EA5CC0.8040102@sun.co...
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.
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.