Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id B95862E004D for ; Thu, 27 Mar 2008 07:14:24 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 66837-06 for ; Thu, 27 Mar 2008 07:14:13 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from fg-out-1718.google.com (fg-out-1718.google.com [72.14.220.156]) by postgresql.org (Postfix) with ESMTP id C83712E0031 for ; Thu, 27 Mar 2008 07:14:18 -0300 (ADT) Received: by fg-out-1718.google.com with SMTP id 22so4074311fge.23 for ; Thu, 27 Mar 2008 03:14:17 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; bh=AHsKoAhia8qes1aQRsOR1MpHA/UnqhDd8yezX5Pd9iw=; b=SrU4WcQANX1+00VfH44bq5AZFM2ieRQBoT1Ft+e65ue5sP4UUDT+ClX0QHO755mGxNmV71FnSxiKSgostl7HjBelRyuRMZVYIXtBUICft9EV0lMWuYoRr4dOVDFX1pxJu3ZXsyFuc0F5uHmLpBnxTtzPGJ7wzek9BeW4YpPcazg= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=tarAyY7f0tcWNIAhr2SNLbkzPWLOJzOybmPH4tRhsAazCKLfu5mNoE0laCo82EyRRMPwWtzck7hJkc8XN8miqxg8u/GMIfIWen/ICf1LZxahoYac1juRt8zuPcd8rilaKlCcsbqYKkQcEyxFTFgc2ti5JtDSoaqhkt5LrS9qiY0= Received: by 10.86.26.11 with SMTP id 11mr719306fgz.74.1206612857269; Thu, 27 Mar 2008 03:14:17 -0700 (PDT) Received: by 10.86.90.14 with HTTP; Thu, 27 Mar 2008 03:14:17 -0700 (PDT) Message-ID: <179149fe0803270314u3c25488eu8315be39bfa9a9a3@mail.gmail.com> Date: Thu, 27 Mar 2008 11:14:17 +0100 From: "=?UTF-8?Q?Marcin_St=C4=99pnicki?=" To: "Shavonne Marietta Wijesinghe" Subject: Re: Export Access 97 to PostgreSQL Cc: "Ivan Sergio Borgonovo" , pgsql-sql@postgresql.org In-Reply-To: <007201c88ff2$404ffa60$0602a8c0@DREAM> MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <002001c88f37$107363b0$3102a8c0@dream> <200803261621.55622.postgres@xmtservices.net> <004a01c88fe9$7dc58df0$0602a8c0@DREAM> <20080327105436.36e13506@webthatworks.it> <007201c88ff2$404ffa60$0602a8c0@DREAM> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200803/196 X-Sequence-Number: 30524 On Thu, Mar 27, 2008 at 11:06 AM, Shavonne Marietta Wijesinghe wrote: > COPY REGIONI FROM (...) > Strange coz i created the table. Why doesn't it seem to find it?? > > CREATE TABLE "REGIONI" You need to quote the name in your COPY command as well.