PostgreSQL Minimal Toturial

1 · · Aug. 30, 2019, 11:45 a.m.
I wrote this old note a while ago while reading the PostgreSQL docs release, I used it then as a mini-reference or a tiny cheat sheet for SQL problems using PostgreSQL. It might (0.3%) be useful to someone so I decided to publish it here. Note: SQL commands is not case sensitive, therefore SELECT = select = SeLeCt Selecting Regular Selection Select syntax is being like this: SELECT * -- Everything FROM real_person -- Table Name LIMIT 10; -- Getting only they very first 5 IDs....