Re: Had to drop some table columns, managed to annoy MS - Mailing list pgsql-novice

From Josh Berkus
Subject Re: Had to drop some table columns, managed to annoy MS
Date
Msg-id 200301131518.09041.josh@agliodbs.com
Whole thread Raw
In response to Re: Had to drop some table columns, managed to annoy MS  (Cheryl Thompson <cthompso@ci.irving.tx.us>)
List pgsql-novice
Cheryl,

> Is there a way to copy/export the DB (or it's tables) to another DB and dump
> all this stuff that's causing the problems? In particular, in the past I
> have exported the entirety of a database into a flat file and imported it
> into a "clean" version. Admittedly, it's been a while and that was for an
> app using DB2 which didn't have a lot of built in tools, but the theory
> applies...

Sure.   Use pg_dump.  See the docs under "Server Programs" or your favorite
PostgreSQL book.

--
-Josh Berkus
 Aglio Database Solutions
 San Francisco


pgsql-novice by date:

Previous
From: "Juliet May"
Date:
Subject: Re: Had to drop some table columns, managed to annoy MS
Next
From: Lex Berezhny
Date:
Subject: Re: Had to drop some table columns, managed to annoy MS