Re: Copying table to another database.

On Tue, 17 Sep 2002, Wim wrote:

> Anyone knows how to copy a table to another database?

Use the the COPY command:

Name
COPY -- copy data between files and tables

Synopsis

COPY [ BINARY ] table [ WITH OIDS ]
FROM { 'filename' | stdin }
[ [USING] DELIMITERS 'delimiter' ]
[ WITH NULL AS 'null string' ]

COPY [ BINARY ] table [ WITH OIDS ]
TO { 'filename' | stdout }
[ [USING] DELIMITERS 'delimiter' ]
[ WITH NULL AS 'null string' ]

Or, bearing in mind your problem,

pg_dump -t <tablename> ...

For your real problem, it sounds like it's the system tables causing you
problems. You say you tried REINDEX, that was REINDEX DATABASE <dbname> FORCE
presumably.

It is somewhat worrying that the same problem has reoccured. You checked your
hard disk but what about memory?

pg_dumpall fails but what about just pg_dump on the individual DBs?

Is it a production system? If it continues to cause problems what about
considering bringing someone in to investigate?

--
Nigel J. Andrews
Director

---
Logictree Systems Limited
Computer Consultants