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