Home > mailing lists

Re: schemas in functions - Mailing list pgsql-novice

From	A. Kretschmer
Subject	Re: schemas in functions
Date	February 3, 2006 09:03:48
Msg-id	20060203100342.GB17468@webserv.wug-glas.de Whole thread Raw
In response to	schemas in functions (Arnaud Lesauvage <thewild@freesurf.fr>)
List	pgsql-novice

Tree view

am  03.02.2006, um 10:48:45 +0100 mailte Arnaud Lesauvage folgendes:
> So I want to be able to call this function with the schema name as a
> parameter, so that all underlying queries are run in the appropriate
> schema.

Please read:
http://www.postgresql.org/docs/8.1/interactive/plpgsql-statements.html#PLPGSQL-STATEMENTS-EXECUTING-DYN


HTH, Andreas
--
Andreas Kretschmer    (Kontakt: siehe Header)
Heynitz:  035242/47215,      D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
 ===    Schollglas Unternehmensgruppe    ===

pgsql-novice by date:

From: Arnaud Lesauvage
Date: 03 February 2006, 08:48:48
Subject: schemas in functions

From: Arnaud Lesauvage
Date: 03 February 2006, 10:58:20
Subject: Create table and update it within one function ?

Re: schemas in functions - Mailing list pgsql-novice

Previous

Next