Hard pass.
Explaining text column types without mentioning limiting length with constraints instead of using varchar also seems a bit questionable to me.
PostgreSQL is a powerful, open-source relational database. Please read the official documentation to learn more.
Postgres by Example is a hands-on introduction to PostgreSQL using annotated SQL examples. Check out the first example or browse the full list below.
Prerequisites: PostgreSQL installed and the server running. Examples assume you can connect with psql; the default database is postgres unless noted. Start the server with your system's service manager or pg_ctl start as needed.
Unless stated otherwise, examples target current stable PostgreSQL. Use the latest version you can if something isn't working.
Licensed under CC BY 4.0.
by Dariush Abbasi | source