Using psql variables in scripts

From: Corey Horton <Corey_Horton(at)messageone(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Using psql variables in scripts
Date: 2008-05-30 17:39:14
Message-ID: C12DE7393B7AFA45BFD2A8BDC4BD440104CA8337@auscorpex-1.austin.messageone.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Browse pgsql-admin by date

  From Date Subject
Next Message Ivo Rossacher 2008-05-30 17:46:32 Re: Migration from ASCII to UTF8
Previous Message Igor Neyman 2008-05-30 16:32:29 dobc install error on Windows