From: | Russell Smith <mr-russ(at)pws(dot)com(dot)au> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Error Message Importing Into PostgreSQL (Using phpPgAdmin) |
Date: | 2004-09-01 05:29:42 |
Message-ID: | 200409011529.42421.mr-russ@pws.com.au |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Wed, 1 Sep 2004 12:53 pm, Daniel Secomb wrote:
> Hi,
>
> I'm using PostgreSQL 7.3.4 with phpPgAdmin 2.4.2 and the ".sql" file I'm
> trying to import came from a dump from a server running PostgreSQL 7.0.3.
>
I'd suggest a phpPgAdmin upgrade 3.4 is the latest.
> I just got this error message trying to import the PostgreSQL database file
> into phpPgAdmin. The error message was as follows:
>
> Error -
> /usr/local/psa/admin/htdocs/domains/databases/phpPgAdmin/db_readdump.php --
> Line: 33
> PostgreSQL said: ERROR: parser: parse error at or near "\" at character 1
> Your query:
> \connect - postgres
> CREATE SEQUENCE "acls_bannerid_seq" start 1 increment 1 maxvalue 2147483647
> minvalue 1 cache 1 ;
>
This is designed to be sent to psql, which understands \connect.
phpPgadmin does not. I would suggest restoring using psql.
Regards
Russell Smith
From | Date | Subject | |
---|---|---|---|
Next Message | Suresh Tri | 2004-09-01 05:31:34 | Re: Overloading '<' operator |
Previous Message | Vidyasagara Guntaka | 2004-09-01 05:27:02 | Re: Not able to build libpq for Windows |