Re: some questions : psql - Mailing list pgsql-general

From Pavel Stehule
Subject Re: some questions : psql
Date
Msg-id Pine.LNX.4.44.0505031421130.7037-100000@kix.fsv.cvut.cz
Whole thread Raw
In response to some questions : psql  ("FERREIRA, William (COFRAMI)" <william.ferreira@airbus.com>)
List pgsql-general
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, and several functions need to access this folder, so is it possible to
passthe 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
\i global.sql

SELECT somefce(:TempDirectory)

>
>

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
consequencethe 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


Regards
Pavel Stehule


pgsql-general by date:

Previous
From: Vlad
Date:
Subject: Re: [Dbdpg-general] Re: 'prepare' is not quite schema-safe
Next
From: Robin Boerdijk
Date:
Subject: Deep integration of PostgreSQL with Apache