Using psql variables in scripts

[Corey Horton <Corey_Horton@xxxxxxxxxxxxxx>]

Would like to use variables in combination with files for common psql queries, and am using PG 8.1.4.

 

For example

\set table_name pg_class

 

select * from pg_tables where tablename = ‘:table_name’;

 

This returns no rows, even though the customer table exists.  It appears to be search for a table called ”:table_name”.

 

I can get this to work by doing the following:

 

\set table_name '\'pg_class\''

select * from pg_tables where tablename = :table_name;

 

 schemaname | tablename | tableowner | tablespace | hasindexes | hasrules | hastriggers

------------+-----------+------------+------------+------------+----------+-------------

 pg_catalog | pg_class  | postgres   |            | t          | f        | f

 

 

Is there any way to do use variables within quotes?

 

Thanks,
Corey Horton