"But this adds the column at the end." - column order in the table
definition is unreliable; when you output you should specify the column
order yourself.
As to populating within a sequence that has missing values that is more
trouble than it is worth.
If you want to add a column and make i
On 02/11/2011 12:13 PM, Adarsh Sharma wrote:
Dear all,
I have an Integer column in Postgres database table. Let's say the
column has below values :
1
2
3
4
5
6
7
8
9
10
Now if i deleted some rows where id= 3 ,5 and 8 or it have these type
of data then
The data look like as :
1
2
4
6
On 11 February 2011 11:13, Adarsh Sharma wrote:
> Dear all,
>
>
> I have an Integer column in Postgres database table. Let's say the column
> has below values :
>
>
> 1
> 2
> 3
> 4
> 5
> 6
> 7
> 8
> 9
> 10
>
>
> Now if i deleted some rows where id= 3 ,5 and 8 or it have these type of
> data then
