Sorry, my fault that I run the script in the query window of pgAdmin, not in
the system console. I check it again in the system console and it works
well.
Thanks,
Sabin
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.pos
Sabin Coanda wrote:
> Hi,
>
> I have "PostgreSQL 8.3.5, compiled by Visual C++ build 1400" on Windows OS.
>
> I try to use the COPY command to optimize the backup/restore performance,
> but I found a problem. I reproduce it below.
I can't reproduce it here on 8.3 on linux.
> I backup the datab
> Is that the *first* error message you got?
>
Yes it is.
In fact I made a mistake in the first email, so instead:
INSERT INTO "A" ( "Col1", "Col2" )
VALUES (2, '-- any text' );
please change with:
INSERT INTO "A" ( "Col1", "Col2" )
VALUES (1, '-- any text' );
Ho
"Sabin Coanda" <[EMAIL PROTECTED]> writes:
> I backup the database plain with the command:
> pg_dump.exe -U postgres -F p -v -f "backup_plain.sql" "DemoDB"
> I create a new database, and I run the script. But it rise me the error:
> ERROR: syntax error at or near "1"
> LINE 49: 1 -- any text
Hi,
I have "PostgreSQL 8.3.5, compiled by Visual C++ build 1400" on Windows OS.
I try to use the COPY command to optimize the backup/restore performance,
but I found a problem. I reproduce it below.
I create a database with a simple table:
CREATE TABLE "A"
(
"Col1" integer NOT NULL,
