Received: from smtp.snet.net (smtp.snet.net [204.60.6.55]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f6HKrMa86321 for ; Tue, 17 Jul 2001 16:53:22 -0400 (EDT) (envelope-from wweng@kencast.com) Received: from pop.snet.net (pop.snet.net [204.60.6.9]) by smtp.snet.net (8.11.1/8.11.1/SNET-mx-1.4/D-1.10/O-1.7) with ESMTP id f6HKrGC28293; Tue, 17 Jul 2001 16:53:18 -0400 (EDT) Received: from [192.168.1.83] (167.95.252.64.snet.net [64.252.95.167]) by pop.snet.net (8.11.1/8.11.1/SNET-pop-1.5/D-1.8/O-1.6) with ESMTP id f6HKrFr06645; Tue, 17 Jul 2001 16:53:15 -0400 (EDT) Subject: Re: PL/PGSQL and external (flat ASCII) files - Urgent ... :) From: Wei Weng To: Chris Ruprecht Cc: p-sql In-Reply-To: <015e01c10eff$0ea18400$5dd26383@corp.compucom.com> References: <015e01c10eff$0ea18400$5dd26383@corp.compucom.com> Content-Type: text/plain X-Mailer: Evolution/0.10 (Preview Release) Date: 17 Jul 2001 17:59:11 -0400 Message-Id: <995407162.31302.0.camel@Monet> Mime-Version: 1.0 X-Archive-Number: 200107/232 X-Sequence-Number: 4028 You can probably try to make a c extension that does open/close. On 17 Jul 2001 15:28:36 -0500, Chris Ruprecht wrote: > Hi all, > > I need to know how I can access a flat file from within a PL/PGSQL script. > I have an Oracle PL/SQL book here and they refer to FOPEN(...), FCLOSE(...) > but these functions don't seem to exist in PL/PGSQL.. What can I do instead? > I checked the Programmer's Guide to Procedural Languages (PostGreSQL 7.1.2 > and 7.2) but there is no info on it. > > Best regards, > Chris > > > > _________________________________________________________ > Do You Yahoo!? > Get your free @yahoo.com address at http://mail.yahoo.com > > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://www.postgresql.org/search.mpl > -- Wei Weng Network Software Engineer KenCast Inc.