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 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
On Fri, Jul 29, 2005 at 11:24:37PM -0400, Bruce Momjian wrote:
>
> Would someone who knows perl update plperl.sgml and send me a patch?
>
> Also, is this still true in 8.1:
>
> In the current implementation, if you are fetching or returning
> very large data sets, you should be aware
