variables in psql

Does postgres support the use of variables as in the example below?

update table1 set column1=(at)variable
where column2='text4column2'
and @variable=(select column3 from table2 where column4='text4column4');

If not, how do I execute a statement like this in postgres?