租户端 数据库 TDSQL PostgreSQL 版 开发指南 修改表 修改表结构场景 给表增加字段

给表增加字段

最近更新时间: 2025-02-18 16:02:00

  • 复制
    复制成功
postgres=# alter table tbase add column age integer;
ALTER TABLE
postgres=# \d+ tbase
                                              Table "public.tbase"
  Column  |  Type   |                   Modifiers                    | Storage  | Stats target |   Description   
----------+---------+------------------------------------------------+----------+--------------+-----------------
 id       | integer | not null default nextval('t_id_seq'::regclass) | plain    |              | 
 nickname | text    |                                                | extended |              | TDSQL PG呢称是大象
 age      | integer |                                                | plain    |              | 
Has OIDs: no
Distribute By SHARD(id)
        Location Nodes: ALL DATANODES