sql - How to use a psql variable in the middle of other characters? -

i wondering if possible use variable in middle of other characters in sql statement psql.

for example:

psql -v x=apple -f "example.sql"

with example.sql being:

select * :x;

works fine. it's executed as:

select * apple;

but how handle situation example.sql like:

select * red_:x_pie;

i want psql read "red_apple_pie" syntax error on ":" instead.

thanks.

you'll have use string concatenation:

declare x text;  begin x = 'apple';  select * "food" "name" = 'red_' || x || '_pie';

i used example because it's simpler understand (table names have enclosed in quotes).

IO