On Feb 24, 2009, at 1:07 PM, Albe Laurenz wrote:
Kevin Duffy wrote:
I need guidance on how move some changes that I have made to
my production database.
A few thoughts:
Maybe you do not need to delete and recreate the table.
An ALTER TABLE statement can, for example, add a column to
an exist
Kevin Duffy wrote:
> I need guidance on how move some changes that I have made to
> my production database.
>
> On my development database I made changes to a table called
> DEPT. I added a column, added
>
> a couple of records and did some general data cleanup
>
>
>
> What I did not do w
Hello All:
I need guidance on how move some changes that I have made to my
production database.
On my development database I made changes to a table called DEPT. I
added a column, added
a couple of records and did some general data cleanup
What I did not do was change any of the keys
From: "Liz Pelletier" <[EMAIL PROTECTED]>
> If I have a dump of myDB, and I want to restore only two tables from
> this dump, is there a way to do this? Or do I have to restore the entire
> db?
>
> (BTW, using 7.1 on a Debian box.)
Try pg_restore if you used pg_dump's new option (never tried it
$ pg_restore --help
.
.
.
-t, --table[=TABLE] restore this table only
.
.
.
cheers,
thalis
On Wed, 18 Jul 2001, Liz Pelletier wrote:
> If I have a dump of myDB, and I want to restore only two tables from
> this dump, is there a way to do this? Or do I have to restore the entire
> db?