Topics

• Postgres Tip and Tricks
• Entity-Framework with Postgresql
• Postgres cryptographic functions

Examples

• 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
• Pre-Steps needed in order to use Entity Framework 6.1.3 with PostgresSql using Npgsqlddexprovider
• digest