Re: Had to drop some table columns, managed to annoy MS

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Cheryl Thompson <cthompso(at)ci(dot)irving(dot)tx(dot)us>, "'pgsql-novice(at)postgresql(dot)org'" <pgsql-novice(at)postgresql(dot)org>
Cc: 'Tom Lane' <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Subject: Re: Had to drop some table columns, managed to annoy MS
Date: 2003-01-13 23:18:09
Message-ID: 200301131518.09041.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Kevin Waterson 2003-01-14 01:46:14 Data types
Previous Message Juliet May 2003-01-13 23:12:40 Re: Had to drop some table columns, managed to annoy MS