How to Substitute Variables in PostgreSQL
These variables are a feature of SQL*Plus.

psql, the equivalent program in the PostgreSQL world, also has variables.

Use

\set variable 'value'


and

insert into mytable(mycolumn)
values (:variable);