I have a database to store the information about the html source of the
web page.
I wan't to move the data to another database, so I pg_dump the data to a
file:
/usr/local/pgsql/bin/pg_dump htmldb -Upostgres -p 5433 > /tmp/dump.sql
now, I load the data into new database:
/usr/local/pgsql/bin/psql -d newbd -Upostgres -p 5432 -f /tmp/dump.sql
but, I got some error about the "column error", for example:
----
psql:/export/chry.sql:1965134: ERROR: missing data for column "content"
CONTEXT: COPY htmlcontent, line 312807: "1207327 <!DOCTYPE HTML PUBLIC
"-//W3C//DTD
HTML 4.0 Transitional//EN">\n<html>\n<head>\n<meta http-e..."
----
I don't konw that why I can store it in a database, but I can't dump it
and reload into another one.
how to fix it?
my postgresql version: 8.3.3
thanks,
regards,
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
No comments:
Post a Comment