Skip site navigation (1) Skip section navigation (2)

using vars in scripts

From: "pablo sebastian rodriguez" <psrodriguez(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: using vars in scripts
Date: 2006-06-24 00:37:03
Message-ID: (view raw or whole thread)
Lists: pgsql-novice

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

Next:From: Volkan YAZICIDate: 2006-06-24 11:45:33
Subject: Re: libpq Describe Extension [WAS: Bytea and perl]
Previous:From: operationsengineer1Date: 2006-06-24 00:03:50
Subject: Re: Copy Data Question

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group