RE: can we write to a flat file from Postgresql procedure

I don't think there is any way to do this using any of the generally
available tools.

You could do a workaround using pl/pgsql, in the following way:
* insert your data into a temp table
* output the data to a file using COPY

pl/pgsql allows INSERT statements, but does not allow CREATE/DROP TABLE or
COPY statements. Those can be constructed using EXECUTE, which takes a
string (which can be constructed using parameters) and passes it on to be
executed as an SQL statement.

For more information, check out the PostgreSQL documentation, especially on
pl/pgsql (under "Procedural Languages") and COPY (under "SQL Commands").

> -----Original Message-----
> From: R Vijayanath [SMTP:vijayanath(at)yahoo(dot)com]
> Sent: Thursday, July 05, 2001 10:34 AM
> To: pgsql-sql(at)postgresql(dot)org
> Subject: can we write to a flat file from Postgresql procedure
>
> Hi,
>
> I found your name in the Postgresql web site.
>
> It would be great if you can tell me if I can write a
> procedure that can write the output to the OS(Linux
> OS) file.
>
> Can you assist me on this if there is a way to do it.
>
> We are using Postgresql 7.1 running in Linux Redhat
> 7.1.
>
> Thanks in Advance.
>
> Vijay
>
>
> __________________________________________________
> Do You Yahoo!?
> Get personalized email addresses from Yahoo! Mail
> http://personal.mail.yahoo.com/
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly