Using psql variables in scripts

Поиск
Список
Период
Сортировка
От Corey Horton
Тема Using psql variables in scripts
Дата
Msg-id C12DE7393B7AFA45BFD2A8BDC4BD440104CA8337@auscorpex-1.austin.messageone.com
обсуждение исходный текст
Список 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

В списке pgsql-admin по дате отправления:

Предыдущее
От: "Igor Neyman"
Дата:
Сообщение: dobc install error on Windows
Следующее
От: "Igor Neyman"
Дата:
Сообщение: odbc install error on Windows