HGDB PG表中添加删除列

最新推荐文章于 2024-08-13 15:51:00 发布

lk_db

最新推荐文章于 2024-08-13 15:51:00 发布

阅读量1.1k

点赞数

分类专栏： Highgo DB PostgreSQL

本文链接：https://blog.csdn.net/lk_db/article/details/78039155

版权

Highgo DB 同时被 2 个专栏收录

171 篇文章 2 订阅

订阅专栏

PostgreSQL

162 篇文章 2 订阅

订阅专栏

HGDB表中添加删除列：

highgo=# \d test
Table "public.test"
Column | Type | Modifiers
--------+---------+------------
id | integer | default 15
no | integer |

highgo=# select * from test;
id | no
----+----
15 | 1
15 | 2
15 |
(3 rows)

highgo=# alter table test add column name varchar(10);
ALTER TABLE
highgo=# select * from test;
id | no | name
----+----+------
15 | 1 |
15 | 2 |
15 | |
(3 rows)

highgo=# insert into test (no,name) values (1,'a');
INSERT 0 1
highgo=#
highgo=# select * from test;
id | no | name
----+----+------
15 | 1 |
15 | 2 |
15 | |
15 | 1 | a
(4 rows)

highgo=# alter table test drop column name;
ALTER TABLE
highgo=# select * from test;
id | no
----+----
15 | 1
15 | 2
15 |
15 | 1
(4 rows)