Topics
- Getting started with C++
- Getting started with postgresql
- Role Management
- Backup and Restore
- Programming with PL/pgSQL
- Installing Bash on Windows 10
- Postgres Tip and Tricks
- Data Types
- Recursive queries
- Postgres cryptographic functions
- Event Triggers
- Real Application Security
Examples
- Create a user with a password
- Create Role and matching database
- Using psql to export data
- Alter default search_path of user
- DATEADD alternative in Postgres
- Comma seperated values of a column
- Delete duplicate records from postgres table
- Update query with join between two tables alternative since Postresql does not support join in update query.
- Difference between two date timestamps month wise and year wise
- Query to Copy/Move/Transafer table data from one database to other database table with same schema
- Function
- Install PostgreSQL from Source on Linux
- PL/pgSQL Syntax
- RETURNS Block
- Install Bash under Windows 10
- Numeric Types
- Date/ Time Types
- Geometric Types
- Network Adress Types
- Character Types
- Sum of Integers
- Arrays
- digest
- Logging DDL Command Start Events
- Application
