Received: from nezu.gs.verio.net (nezu.gs.verio.net [204.27.65.34]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f6BFFNa13549 for ; Wed, 11 Jul 2001 11:15:23 -0400 (EDT) (envelope-from jeckermann@verio.net) Received: by NEZU with Internet Mail Service (5.5.2650.21) id <3G6FW6SV>; Wed, 11 Jul 2001 10:15:10 -0500 Message-ID: <08CD1781F85AD4118E0800A0C9B8580B094B26@NEZU> From: Jeff Eckermann To: "'R Vijayanath'" , pgsql-sql@postgresql.org Subject: RE: can we write to a flat file from Postgresql procedure Date: Wed, 11 Jul 2001 10:15:09 -0500 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2650.21) Content-Type: text/plain X-Archive-Number: 200107/145 X-Sequence-Number: 3937 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@yahoo.com] > Sent: Thursday, July 05, 2001 10:34 AM > To: pgsql-sql@postgresql.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@postgresql.org so that your > message can get through to the mailing list cleanly