9.4.1. format

From: PG Doc comments form <noreply(at)postgresql(dot)org>
To: pgsql-docs(at)lists(dot)postgresql(dot)org
Cc: y(dot)saburov(at)gmail(dot)com
Subject: 9.4.1. format
Date: 2026-09-19 05:52:22
Message-ID: 178979714249.1241.1230833804069549466@wrigleys.postgresql.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-docs

The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/18/functions-string.html
Description:

>> Here are some examples of the basic format conversions:

```html
SELECT format('INSERT INTO %I VALUES(%L)', 'locations', 'C:\Program Files');
Result: INSERT INTO locations VALUES('C:\Program Files')
```

```sql
db=# SELECT format('INSERT INTO %I VALUES(%L)', 'locations', 'C:\Program
Files');

format
----------------------------------------------------
INSERT INTO locations VALUES(E'C:\\Program Files')
```

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message David G. Johnston 2026-09-19 13:55:27 Re: 9.4.1. format
Previous Message Kacper Kuras 2026-09-18 16:34:05 Re: 8.5.1. Date/Time Input