postgresql表中间加列_PostgreSQL修改列与重写表

postgres=# \d tab_kenyon

Table "public.tab_kenyon"

Column | Type | Modifiers

--------+-----------------------+-----------

id | integer |

name | character varying(35) |

remark | text | 验证过程如下：

postgres=# vacuum full tab_kenyon;

VACUUM

postgres=# select ctid,* from tab_kenyon ;

ctid | id | name | remark

-------+----+--------------+--------

(0,1) | 1 | kenyon |

(0,2) | 2 | china |

(0,3) | 5 | oopoo |

(0,4) | 45 | xxooxx |

(0,5) | 4 | i love china |

(5 rows)

postgres=# update tab_kenyon set name = 'kenyon_test' where id = 5;

UPDATE 1

postgres=# select ctid,* from tab_kenyon ;

ctid | id | name | remark

-------+----+--------------+--------

(0,1) | 1 | kenyon |

(0,