Re: Adding Missing Data to a Table

From: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
To: pdxpug(at)postgresql(dot)org
Subject: Re: Adding Missing Data to a Table
Date: 2011-03-29 22:37:33
Message-ID: alpine.LNX.2.00.1103291536180.28359@salmo.appl-ecosys.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pdxpug

On Tue, 29 Mar 2011, Dan Colish wrote:

> Well there are good docs for setting up a sequence. As for setting it up
> on your table, I believe an ALTER COLUMN using the sequence nextval as
> default should do it. Best to test this one out before doing it for real.

Thanks, Dan.

> Here are the docs for sequence: http://www.postgresql.org/docs/current/static/sql-createsequence.html

This is good to know. A third option for me.

Good lessons from all of you.

Rich

In response to

Browse pdxpug by date

  From Date Subject
Next Message Roderick A. Anderson 2011-03-30 04:26:14 Re: Adding Missing Data to a Table
Previous Message Rich Shepard 2011-03-29 22:35:55 Re: Adding Missing Data to a Table