Category: PostgreSQL

Cannot begin/end transactions in PL/pgSQL Rollback The cause of error: Cannot begin/end transactions in PL/pgSQL is the rollback command. The solution is to use exception clause in the function. Wrong function CREATE OR REPLACE FUNCTION update_test (p_old_name varchar, p_new_name varchar) RETURNS...

Column must appear in the GROUP BY clause or be used in an aggregate function GROUP BY clause The cause of error: Column must appear in the GROUP BY clause or be used in an aggregate function The solution is to...

Column specified more than once Duplicate column The cause of error: Column specified more than once. The solution is to remove duplicate columns. Wrong insert INSERT INTO test.students (id, first_name, first_name) VALUES (6, 'Paul', 'Paul'); ERROR: column “first_name” specified more than...

Create postgresql database Create database syntax, alter database examples, rename and drop. Syntax CREATE DATABASE db_name [ [ WITH ] [ OWNER [=] username ] [ TEMPLATE [=] template ] [ ENCODING [=] encoding ] [ LC_COLLATE [=] lc_collate ] [...

Create postgresql schema Create schema syntax, Alter schema with examples. Syntax CREATE SCHEMA schema_name [ schema_element [ ... ] ]; CREATE SCHEMA AUTHORIZATION username [ schema_element [ ... ] ]; Example CREATE SCHEMA test; Create a schema for user user_1, and...