SELECT * from the_world; Why & how SQL rocks
Important
- string literals are enclosed in single quotes
- quoted identifiers are enclosed in double quotes
- boolean equals operator is
=, not== - there is no such thing as natural order. Order of records is random unless set explicitly
- SQL queries run in the order shown below. The syntax order is very different
Ted Neward's ORM - The Vietnam of Computer Science
About foreign data - Postgres OnLine Journal Windows binaries of FDW & extensions here and here
ECB Foreign Exchange Rates history
My State machines' farm implementation
Tip
Since 2025-10-01 JetBrains DataGrip database management IDE is free for non-commercial use!
You may give it a try. It scores a bit higher than DBeaver.