Re: plpgsql question

From: Alejandro Javier Pomeraniec <apomeraniec(at)buenosaires(dot)gov(dot)ar>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: plpgsql question
Date: 2004-05-05 13:37:03
Message-ID: 20040505103703.0524c154.apomeraniec@buenosaires.gov.ar
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi again !

I'm trying to export query results to a file inside a plpgsql function, is there any way to achieve this?

Thanks !!

On Wed, 05 May 2004 09:27:20 -0400
Bill Moran <wmoran(at)potentialtech(dot)com> wrote:

> Alejandro Javier Pomeraniec wrote:
> > Hi !!
> >
> > Is it possible to put inside a plpgsql function psql commands like \pset ?
>
> No. These commands are handled by psql, not the Postgres server.
>
> It's likely that there's a method of doing what you want on the back-end though,
> although it might not be as easy as it is in psql.
>
> --
> Bill Moran
> Potential Technologies
> http://www.potentialtech.com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Lonni Friedman 2004-05-05 13:42:04 vacuumdb is failing with NUMBER OF INDEX TUPLES NOT THE SAME AS HEAP
Previous Message Bill Moran 2004-05-05 13:27:20 Re: plpgsql question