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

Re: some questions : psql

From: "FERREIRA, William (COFRAMI)" <william(dot)ferreira(at)airbus(dot)com>
To: Pavel Stehule <stehule(at)kix(dot)fsv(dot)cvut(dot)cz>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: some questions : psql
Date: 2005-05-03 13:34:34
Message-ID: 414D259CE29DE54DAD534037C83CE4B7269578@FR0-MAILMB20.res.airbus.corp (view raw or flat)
Thread:
Lists: pgsql-general
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 :
	DEFINE pool = 10
and use it into a function
	@createMDNS.sql &pool
and my file createMDNS.sql is
	create or replace package body MDXML_EXPORT
	 as
	   pool varchar2(150) := '&1';
		procedure toto(.......
	.....
	.....
	/
that what i wanted to explain

and my new question is :) :
i wrote a first file :
	\set databaseName 'base1'
	\set createMDXML '/home/toto/MDXML/execCreateMDXML.sql'
	\i :createMDXML
and in my second file, i need the name af the database but if i wrote this :
	SET search_path TO :databaseName;
it doesn't work....

regards


-----Message d'origine-----
De : Pavel Stehule [mailto:stehule(at)kix(dot)fsv(dot)cvut(dot)cz]
Envoy : mardi 3 mai 2005 14:30
 : FERREIRA, William (COFRAMI)
Cc : pgsql-general(at)postgresql(dot)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 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
\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 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


Regards
Pavel Stehule


This mail has originated outside your organization,
either from an external partner or the Global Internet. 
Keep this in mind if you answer this message.

This e-mail is intended only for the above addressee. It may contain
privileged information. If you are not the addressee you must not copy,
distribute, disclose or use any of the information in it. If you have
received it in error please delete it and immediately notify the sender.
Security Notice: all e-mail, sent to or from this address, may be
accessed by someone other than the recipient, for system management and
security reasons. This access is controlled under Regulation of
Investigatory Powers Act 2000, Lawful Business Practises.

Responses

pgsql-general by date

Next:From: Alexandre BiancalanaDate: 2005-05-03 13:39:58
Subject: postgresql 8 abort with signal 10
Previous:From: Michelle KonzackDate: 2005-05-03 12:56:14
Subject: Re: REMOVE

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