From: | "William Gerber" <William(dot)Gerber(at)erg(dot)com> |
---|---|
To: | <pgsql-novice(at)postgresql(dot)org> |
Subject: | Writing Text Files from PostgreSQL |
Date: | 2005-11-16 18:10:40 |
Message-ID: | s37b3df1.000@Mail.erg.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Hello. I am brand new to PostgreSQL and I need someone to point me in
the right direction on how to write the results of a function to a text
file. Is it possible to do this within the PostgreSQL PL/pgSQL
language? I have done this before in Oracle using the UTL_FILE commands
and I was hoping that PostgreSQL had similar functionality. I need to
provide some data formatting in the text file that I produce so I don't
think the pg_dump command would work for me (correct me if I am wrong
though). Thanks in advance for any help that you can give.
System Specs:
PostgreSQL 8.1 on Linux
--------------------------------------------------------------
William Gerber
ERG
5608 Parkcrest Drive, Suite 100
Austin, TX 78731-4947
ph: 512-407-1827
fax: 512-419-0089
e-mail: william(dot)gerber(at)erg(dot)com
--------------------------------------------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | Jaime Casanova | 2005-11-16 19:43:18 | Re: Writing Text Files from PostgreSQL |
Previous Message | operationsengineer1 | 2005-11-16 17:42:52 | Re: Problem Connecting to DB After 8.1 Upgrade (SOLVED) |