Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125]) by mail.postgresql.org (Postfix) with ESMTP id DD3CB98F705 for ; Tue, 5 Jun 2012 06:51:46 -0300 (ADT) Received: from mail2.hosting.digiweb.ie ([89.234.64.43]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1SbqQS-0007Pq-L5 for pgsql-php@postgresql.org; Tue, 05 Jun 2012 09:51:45 +0000 Received: (qmail 17167 invoked by uid 399); 5 Jun 2012 09:51:30 -0000 Received: from unknown (HELO ?127.0.0.1?) (music@galwaycathedral.ie@109.76.95.68) by mail2.hosting.digiweb.ie with ESMTPAM; 5 Jun 2012 09:51:30 -0000 X-Originating-IP: 109.76.95.68 Message-ID: <4FCDD6A0.7030107@iol.ie> Date: Tue, 05 Jun 2012 10:51:28 +0100 From: Raymond O'Donnell Reply-To: rod@iol.ie User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:12.0) Gecko/20120428 Thunderbird/12.0.1 MIME-Version: 1.0 To: Archana K N CC: pgsql-php@postgresql.org Subject: Re: Problem in importing database References: In-Reply-To: X-Enigmail-Version: 1.4.1 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Antivirus: avast! (VPS 120605-0, 05/06/2012), Outbound message X-Antivirus-Status: Clean X-Pg-Spam-Score: -1.9 (-) X-Archive-Number: 201206/6 X-Sequence-Number: 4257 On 05/06/2012 06:21, Archana K N wrote: > Hello, > > I got a text file when i exported a database in postgres > using pgadmin it was named 'dump.sql'. And when i tried to import the > same to postgres using pgadmin i got the following error. > > "dump.sql:1: ERROR: syntax error at or near "Dumping" > LINE 1: Dumping of complex table and schema names on Windows is not ... Reading the contents of the file will give you the answer... :-) Looks like you got an error message instead of a dump. Also, I'd guess from the above that you used PhpPgAdmin, not pgAdmin; they're two very different animals. Ray. -- Raymond O'Donnell :: Galway :: Ireland rod@iol.ie