hi, all: 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,
