Skip site navigation (1) Skip section navigation (2)

Re: Problem in importing database

From: Raymond O'Donnell <rod(at)iol(dot)ie>
To: Archana K N <archanakknn(at)gmail(dot)com>
Cc: pgsql-php(at)postgresql(dot)org
Subject: Re: Problem in importing database
Date: 2012-06-05 09:51:28
Message-ID: 4FCDD6A0.7030107@iol.ie (view raw or flat)
Thread:
Lists: pgsql-php
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(at)iol(dot)ie

In response to

Responses

pgsql-php by date

Next:From: Archana K NDate: 2012-06-05 10:17:52
Subject: Re: Problem in importing database
Previous:From: Archana K NDate: 2012-06-05 05:21:19
Subject: Problem in importing database

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group