Welcome to the ongoing series of posts by Grant as he takes his vast knowledge of SQL Server and applies it to adding PostgreSQL and shares it with you so you can skip learn from his triumphs and mistakes.
- Connecting to PostgreSQL
- Creating a Database and Tables in PostgreSQL
- How to back up and restore with PostgreSQL
- Data Types in PostgreSQL
- Index Types in PostgreSQL
- PostgreSQL Constraints
- PostgreSQL Schema
- Manipulating Data In PostgreSQL
- Querying PostgreSQL
- Introducing VACUUM
- Functions and Procedures
Stay tuned for more entries in the upcoming future!