PG_ESCAPE_BYTEA(n)

💖 NAME 💖

okay bestie, this page is PG_ESCAPE_BYTEA() from the PostgreSQL Tcl Interface Documentation, and it does exactly one iconic thing: pg_escape_bytea — escapes a binary string for inclusion into SQL statements. periodt. ✨

✨ SYNOPSIS ✨

pg_escape_bytea string

🦋 DESCRIPTION 🦋

pg_escape_bytea escapes a binary string, making it safe for inclusion into SQL statements. like, it's giving “SQL-safe binary string” main character energy, no cap. 💅

here’s the example exactly as it appears, bestie:

pg_exec $conn "insert into foo values ([pg_escape_binary $name]);"

🎀 ARGUMENTS 🎀

• binary_string — the binary string to be escaped. that’s the whole vibe. 🫶

🌸 RETURN VALUE 🌸

Returns the binary string, escaped for inclusion into SQL queries. slay. 🔥

mwah 💋 — this little page is from the PostgreSQL Tcl Interface Documentation, dated 17 September 2020. iconic, honestly. 👑