In PostgreSQL, strings can be quoted very flexibly using a pair of dollar signs (
$) with a tag in between. For example,
SELECT $f$ Hi $f$;
Is this quoting mechanism a part of any SQL standard, or is it postgres specific?
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.Sign up to join this community
NO its postgresql specific many programing languages offer a way to write text that avoids having to be escaped
Also keep in mind Postgtesql from version 9.1 by default no longer allows passing escape string in a query, it has to have a leading E
to be escaped now see standard conforming string