Re: using vars in scripts

Поиск
Список
Период
Сортировка
От LLC
Тема Re: using vars in scripts
Дата
Msg-id 1151359292.v2.fusewebmail-164106@f
обсуждение исходный текст
Ответ на using vars in scripts  ("pablo sebastian rodriguez" <psrodriguez@gmail.com>)
Список pgsql-novice
Дерево обсуждения
Postgres offers several methods. I'll assume you're running Linux/bash, if not try and convert the following to whatever OS/shell you're using:
 
# Bash script 1 using a here document:
 
tabname='mytab'
tabcol='username'
 
 
psql <dbname> <<EOF
select $tabcol from $tabname;
EOF!
 
 
# Bash script 2 - using echo:
tabname='mytab'
tabcol='username'
 
echo "select $tabcol from $tabname" | psql <dbname> 
 

There are many variations on these examples, hope this helps...
 
 


----- Original Message -----
Subject: [NOVICE] using vars in scripts
From: "pablo sebastian rodriguez" <psrodriguez@gmail.com>
Date: Fri, June 23, 2006 18:37

hi,

i know this is silly, but i can't find the way...

with mssql i can do this:

declare @my_var varchar(20) ;
set @my_var = 'something' ;
select @my_var ;


with mysql it's even easier:

set @my_var = 'something' ;
select @my_var ;


but, with postgre ? i don't know how to do that...


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