sql

PostgreSQL Tutorial: Event Trigger

Summary: In this tutorial, you will learn about PostgreSQL event triggers and how to use the CREATE EVENT TRIGGER statement to define a new event trigger.

Continue reading

PostgreSQL Tutorial: Correlated Subquery

Summary: In this tutorial, you will learn about PostgreSQL correlated subquery to perform a query that depends on the values of the current row being processed.

Continue reading

PostgreSQL Tutorial: MERGE

Summary: In this tutorial, you will learn how to use the PostgreSQL MERGE statement to conditionally insert, update, and delete rows of a table.

Continue reading

PostgreSQL Tutorial: Moving a Tablespace

Summary: In this tutorial, you will learn how to move a tablespace in PostgreSQL.

Continue reading

PostgreSQL Tutorial: Paginated SELECT

Summary: in this tutorial, you will learn how to paginate the result set returned from the SELECTstatement in PostgreSQL.

Continue reading

PostgreSQL Tutorial: LATERAL JOIN

Summary: In this article, we are going to see how the SQL LATERAL JOIN works, and how we can use it to cross-reference rows from a subquery with rows in the outer table and build compound result sets.

Continue reading

PostgreSQL Tutorial: Subtransaction

Summary: in this tutorial, you will learn how to handle PostgreSQL subtransactions using the SAVEPOINT, ROLLBACK TO SAVEPOINT, and RELEASE SAVEPOINT statements.

Continue reading

PostgreSQL Tutorial: List Triggers

Summary: Triggers are the functions that are fired/invoked when a certain specified event occurs. Sometimes we need to list the triggers in PostgreSQL to know which triggers and how many triggers are associated to a table. In this article, we will look at the methods to list down all the triggers in our database and also list all the triggers related to a table.

Continue reading

PostgreSQL Tutorial: ALTER DATABASE

Summary: in this tutorial, you will learn how to modify existing databases by using PostgreSQL ALTER DATABASE statement.

Continue reading

PostgreSQL Tutorial: ALTER TABLESPACE

Summary: in this tutorial, you will learn how to use the PostgreSQL ALTER TABLESPACE statement to rename, change the owner, or set parameters for a tablespace.

Continue reading