the search_path works well
thanks a lot
-Message d'origine-
De : Pavel Stehule [mailto:[EMAIL PROTECTED]
Envoyé : mardi 3 mai 2005 16:09
À : FERREIRA, William (COFRAMI)
Cc : pgsql-general@postgresql.org
Objet : Re: [GENERAL] some questions : psql
On Tue, 3 May 2005, FERREIRA, Wi
On Tue, 3 May 2005, FERREIRA, William (COFRAMI) wrote:
> sorry, i badly explain my second problem (and it make me think about an other
> question :) )
> what i really want to say is :
> i would like to declare a global variable :
There is one big difference. PostgreSQL don't know global variable
: Pavel Stehule [mailto:[EMAIL PROTECTED]
Envoyé : mardi 3 mai 2005 14:30
À : FERREIRA, William (COFRAMI)
Cc : pgsql-general@postgresql.org
Objet : Re: [GENERAL] some questions : psql
Hello
> 1- is it possible to set a default schema ?
> i tried : set DEFAULT SCHEMA base1; but it did
Hello
> 1- is it possible to set a default schema ?
> i tried : set DEFAULT SCHEMA base1; but it didn't worked
SET search_path to base1;"
>
> 2- is it possible to have one file with global values and to use them when
> creating functions.
> one example is : i have a temporary directory, a
Title: iterate over refcursor
hi,
i have some questions about
psql.
i'm trying to write a script for
deploying my database and i have some questions
:
1- is it possible to set a default schema
?
i tried : set DEFAULT
SCHEMA base1; but it didn't worked
2- is it possible to have one f
