[GENERAL] some questions : psql

[FERREIRA, William (COFRAMI)]

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 file with global values and to use them when creating functions. one example is : i have a temporary directory, and several functions need to access this folder, so is it possible to pass the path as with Oracle     DEFINE TempDirectory = /home/....     @createMDNS.sql &TempDirectory     3- my psql script create 2 tablespaces, an user, the database, 1 schema and the tables and functions but when i launch pgadmin, i see my new user, the tablespace and the database, but I don't see the schema and in consequence the tables and functions. but all have been created because i can ask tables, but they don't appear and i don't know why...;   thank a lot regards       Will