Default Author

Arun Gavhane

Senior Systems Engineer, EDB

Read Blogs

Postgres Tutorials

How to sort rows using ORDER BY and SELECT in PostgreSQL: 6 Examples

This article reviews five ways to sort table data using the ORDER BY clause together with the SELECT statement in PostgreSQL.
Postgres Tutorials

How to modify data in PostgreSQL using INSERT, UPDATE, UPDATE JOINS, DELETE and UPSERT

This article reviews how to use the basic data manipulation language (DML) types INSERT, UPDATE, UPDATE JOINS, DELETE, and UPSERT to modify data in tables.
Postgres Tutorials

How to load a sample database with schemas and data in PostgreSQL

This article discusses how to make a backup of a database using pg_dump in PostgreSQL and provides examples of how to make and restore the backups in different formats.
Postgres Tutorials

How to work with control structures in PostgreSQL stored procedures: Using IF, CASE, and LOOP statements

This article reviews control structures that can be used in PostgreSQL stored procedures, with syntax and examples provided for each.
Postgres Tutorials

How to use clauses when querying data (FROM, WHERE, GROUP BY, HAVING, BETWEEN, LIKE, FETCH)

This article discusses the use of clauses in PostgreSQL queries to filter and organize data in results. It introduces different clauses and provides examples of their usage.
Postgres Tutorials

Porting between Oracle and PostgreSQL

This article discusses the possible complications that can arise when migrating databases from Oracle to PostgreSQL. The steps for migration are covered and issues and their fixes are identified: Approach to migration Schema migration Code migration Data migration When migrating database objects from Oracle to PostgreSQL you may face issues as there are some incompatibilities between Oracle and...