How can I run an ad-hoc script in PostgreSQL?

Use an anonymous code block:

DO language plpgsql $$
BEGIN
  RAISE NOTICE 'hello, world!';
END
$$;

Variables are referenced using %:

RAISE NOTICE '%', variable_name;