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
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 |