Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 1F77E9FB38C for ; Sun, 22 Apr 2007 06:48:22 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 90569-10 for ; Sun, 22 Apr 2007 06:48:18 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from cooma-1.andyshellam.eu (cooma-1.andyshellam.eu [82.165.38.62]) by postgresql.org (Postfix) with ESMTP id 76E119FB38A for ; Sun, 22 Apr 2007 06:48:18 -0300 (ADT) Received: from 81-86-233-75.dsl.pipex.com ([81.86.233.75]:1272 helo=[10.100.9.2]) by cooma-1.andyshellam.eu with esmtpa (Exim 4.66) (envelope-from ) id 1HfYga-0005cJ-VS; Sun, 22 Apr 2007 10:48:49 +0100 Message-ID: <462B2EFA.8060406@mailnetwork.co.uk> Date: Sun, 22 Apr 2007 10:46:34 +0100 From: Andy Shellam Reply-To: andy.shellam-lists@mailnetwork.co.uk Organization: www.AndyShellam.EU User-Agent: Thunderbird 2.0.0.0 (Windows/20070326) MIME-Version: 1.0 To: Trula Thomas CC: pgsql-admin@postgresql.org Subject: Re: Parse the DF file to table References: <441065.1028.qm@web56906.mail.re3.yahoo.com> In-Reply-To: <441065.1028.qm@web56906.mail.re3.yahoo.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200704/196 X-Sequence-Number: 25260 I think you need to provide more information on what you're trying to do, and the version of PostgreSQL you're using, which environment etc. If you're talking about reading a comma-delimited or tab-delimited text file, then see the COPY FROM command. http://www.postgresql.org/docs/8.2/static/sql-copy.html Andy. Trula Thomas wrote: > Hello, please show me how to parse the disk file to table. > Thank you in advance. > Trula > > ------------------------------------------------------------------------ > Ahhh...imagining that irresistible "new car" smell? > Check out new cars at Yahoo! Autos. > > !DSPAM:37,462ade7389294966737205!