> 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, 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
Yes. You can use commands and variables psql.
\set TempDirectory /home/... -- in file global.sql
more on http://developer.postgresql.org/docs/postgres/app-psql.html
> 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...;
I don't know. I don't use pgadmin
In response to
pgsql-general by date
|Next:||From: Radu-Adrian Popescu||Date: 2005-05-03 12:39:02|
|Subject: Re: REMOVE|
|Previous:||From: Vlad||Date: 2005-05-03 12:25:08|
|Subject: Re: [Dbdpg-general] Re: 'prepare' is not quite schema-safe|