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

Re: current_schemas()

From: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: Halley Pacheco de Oliveira <halleypo(at)yahoo(dot)com(dot)br>,pgsql-docs(at)postgresql(dot)org
Subject: Re: current_schemas()
Date: 2005-07-30 03:21:15
Message-ID: 20050730032115.GA21895@alvh.no-ip.org (view raw or flat)
Thread:
Lists: pgsql-docs
On Fri, Jul 29, 2005 at 10:30:13PM -0400, Bruce Momjian wrote:
> 
> Why not just use pg_catalog.current_schemas()?

The function is current_schemas(bool), that's why this example doesn't
work:

> > teste=# SELECT current_schemas();
> > ERROR:  function current_schemas() does not exist
> > HINT:  No function matches the given name and argument types. You may need to add explicit type casts.

-- 
Alvaro Herrera (<alvherre[a]alvh.no-ip.org>)
"Aprende a avergonzarte más ante ti que ante los demás" (Demócrito)

In response to

pgsql-docs by date

Next:From: Bruce MomjianDate: 2005-07-30 03:24:37
Subject: Re: PL/Perl list value return causes segfault
Previous:From: Bruce MomjianDate: 2005-07-30 02:30:13
Subject: Re: current_schemas()

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