A time has come and I need to work with PostgreSQL databases and as it always happens - some things concerning with this work need to be remembered. A best way of doing this is to write an article or, in my case, yet another cheat sheet.
So, here is a cheat sheet for working with PostgreSQL. It is not detailed at all and contains a few commands. And I guess they are useful when you have an experience writing SQL queries and want to know database-specific things. For more detailed cheat sheets there are a plenty good links at the bottom of this post.
Opening PostgreSQL console:
dbname is optional
Working with pgsql console
Also, listing indexes for desired table, e.g. ‘products’: