Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pdxpug by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group