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