What is the scope of a PostgreSQL temp table?...

How to show full definition of function or procedure?...

How to execute PostgreSQL RAISE command dynamically...

How to find if a function exists in PostgreSQL?...

Count not-null columns in row...

Postgres plpgsql with PERFORM data-modifying CTE queries...

Spring test @Sql throws "Unterminated dollar quote started ... Expected terminating $$"...

What does "LANGUAGE plpgsql VOLATILE COST 100" mean in functions...

Why is IS NOT NULL false when checking a row type?...

Select from a table variable...

CRC32 function with PL/pgSQL...

Does Postgresql plpgsql/sql support short circuiting in the where clause?...

How do I enforce uniqueness across parent and child tables without denormalizing my data?...

Dynamically generate columns for crosstab in PostgreSQL...

How to perform a select query in a DO block?...

Using a script variable to generate a stored procedure in Postgresql...

Create a function to get column from multiple tables in PostgreSQL...

How to pass NEW.* to EXECUTE in trigger function...

Escape function for regular expression or LIKE patterns...

Catch pg_cancel_backend in plpgsql...

Record returned from function has columns concatenated...

PostgreSQL: Does an EXCEPTION block automatically release its subtransaction after finishing?...

Can a Postgres Commit Exist in Procedure that has an Exception Block?...

PostgreSQL table variable...

Why is this PostgreSQL function throwing an exception, and how can I tell which input is?...

Examine if one time series column of table has two adjacent time points which have interval larger t...

Store query result in a PL/pgSQL variable...

How to check, if a value is an integer with plpgsql?...

Cast value to type (TEXT) using string representation of type ("TEXT")...

Variables interpreted as values in transaction...