PostgreSQL - Comments

In this article, we would like to show you how to use comments in PostgreSQL.

Quick solution:

xxxxxxxxxx

-- Single-line comment

xxxxxxxxxx

/* 

  Multi-line

  comment

*/

In this example, we use a single-line comment as a code fragment explanation:

xxxxxxxxxx

-- Select all users

SELECT * FROM "users";

In this we use a single-line comment to ignore a statement at the end of the line:

xxxxxxxxxx

SELECT * FROM "users" -- WHERE "name"='Tom';

In this example we use a multi-line comment as a code fragment explanation:

xxxxxxxxxx

/* Select all

 from the "users" table: */

SELECT * FROM "users";

In this example, we use a multi-line comment to ignore many statements:

xxxxxxxxxx

/*SELECT * FROM "users";

SELECT * FROM "products";

SELECT * FROM "orders";*/

SELECT * FROM "departments";

In this example, we use a multi-line comment to ignore part of a line:

xxxxxxxxxx

SELECT "name", /*"surname"*/ "country" FROM "users";