Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 16E57475A8A for ; Tue, 6 Aug 2002 08:14:30 -0400 (EDT) Received: from blaise.dfci.harvard.edu (blaise.dfci.harvard.edu [155.52.45.14]) by postgresql.org (Postfix) with ESMTP id 4D97F47582E for ; Tue, 6 Aug 2002 08:14:29 -0400 (EDT) Received: from jaws.dfci.harvard.edu (jaws.dfci.harvard.edu [155.52.45.36]) by blaise.dfci.harvard.edu (8.9.3/8.9.1) with SMTP id IAA02714 for ; Tue, 6 Aug 2002 08:14:32 -0400 (EDT) Message-Id: <200208061214.IAA02714@blaise.dfci.harvard.edu> Date: Tue, 6 Aug 2002 08:14:32 -0400 (EDT) From: John Zhang Reply-To: John Zhang Subject: Re: copy files to postgresql To: pgsql-sql@postgresql.org MIME-Version: 1.0 Content-Type: MULTIPART/mixed; BOUNDARY=Herd_of_Buffalo_248_000 X-Mailer: dtmail 1.3.0 @(#)CDE Version 1.3.2 SunOS 5.7 sun4u sparc X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200208/85 X-Sequence-Number: 8931 --Herd_of_Buffalo_248_000 Content-Type: TEXT/plain; charset=us-ascii Content-MD5: gCWseE9dbnYSbWLPQ7AiYA== I was trying to copy files to columns of a PostgreSQL database table using \copy ( e. g. \copy mytable (column names here) from 'my file' using delimiters '\t'). PostgreSQL does not seem to like the column names part. Could someone help me with that? Thanks. --Herd_of_Buffalo_248_000 Content-Type: TEXT/plain; name=NoName; charset=us-ascii Content-Description: NoName Content-MD5: TMlCkTSNj0Psv3g5HxkjIQ== Put the text of the welcome message here. --Herd_of_Buffalo_248_000--