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
Why not just use pg_catalog.current_schemas()?
---
Halley Pacheco de Oliveira wrote:
> I would like to know how to use current_schemas(), since SELECT
> current_schemas(); didn't work in
> PostgreSQL 7.4 and 8.0 psql.
>
>
On Tue, Jul 05, 2005 at 08:14:40AM -0300, Halley Pacheco de Oliveira wrote:
> 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.
alvherre=# select curre
I would like to know how to use current_schemas(), since SELECT
current_schemas(); didn't work in
PostgreSQL 7.4 and 8.0 psql.
Halley
PostgreSQL 8.0.3 Documentation
Chapter 16. Server Run-time Environment
16.4. Run-time Configuration
The current effective value of the search path can be examine
