Tiny thing but Cool command for psql

Let's get in psql interactive by


>> psql


Yes, If you wanna see all yours db.


psql>> \l


Select db


psql>> \c


you will get in selected db, then


>> \d    # to display all tables

Comments

Post a Comment

Popular posts from this blog

Difference between apt-get update and apt-get dis-upgrade

The “sudo apt-get upgrade” isn’t necessary. It’s a different type of upgrade from “dist-upgrade” You either run one or the other. “apt-get upgrade” will only update your existing packages while “apt-get dist-upgrade” will update your existing packages, remove obsolete packages and install new available packages as well. You can get breakages either way since new packages might be required as dependencies for upgraded packages in the case of “sudo apt-get upgrade” so using “apt-get dist-upgrade” is still the best way so far. Note: This only applies to LMDE since LMDE is a true rolling release. For any other flavor of Mint you’d use MintUpdate levels 1, 2 and 3 all the way. Perhaps someday Clem and Co. will figure out how to tailor MintUpdate so it works properly in LMDE but considering the rolling aspect of LMDE, I’m at a loss as to how theyn would do that. ref http://b10gger.wordpress.com/2011/03/20/difference-between-apt-get-upgrade-and-apt-get-dist-upgrade/ (thank for this website)
Read more