Little thinks about PSQL

Hi , if you just wanna list all databases on your postgres. It's just
$ psql -l U postgres
and if you wanna drop db. It's just
$ dropdb -U postgres
That's it.

Comments

Post a Comment

Popular posts from this blog

yoh, Sort dict

have a problem with sorting dict by value!!! found something interesting on http://code.activestate.com/recipes/304440/ by Nick Coghlan let's see >>d = {'a':0,'b':1,'c':2} >>d #will get {'a':0,'c':2,'b':1} some solution from Nick >>from operator import itemgetter >>print sorted(d.items(),key=itemgetter(1)) #we get [('a':0),('b':1),('c':2)] # >>>>> a list of tuples it might be useful in the future!!!:) thank nick and activestate
Read more

Byobu + Tmux Tips # 2014-01-22

Scenario#1     As a Byobu-Tmux user, I want to broadcast command to multiple panes. So that I don't have to do the same thing for each pane. solution#1 enter command mode => PREFIX + : active this feature => setw synchronize-panes on deactive => setw synchronize-panes off Scenario#2     As a Byobu-Tmus user, I want to have a shortcut to maximize/minimize current pane. So that I can see/work on specific pane efficiently. solution#1 edit ~/.byobu/keybindings.tmux fill-in these code below # maximum pane and restore unbind + bind + new-window -d -n tmux-zoom 'clear && echo TMUX ZOOM && read' \; swap-pane -s tmux-zoom.0 \; select-window -t tmux-zoom  unbind -  bind - last-window \; swap-pane -s tmux-zoom.0 \; kill-window -t tmux-zoom # resize pane bind H resize-pane -L 1 bind J resize-pane -D 1 bind K resize-pane -U 1 bind L resize-pane -R 1 Scenario#3     As a Byobu-Tmux...
Read more