Postgres SQL学习笔记

1、创建表,添加,查询

create table StuInfo
(
   StuId  SERIAL primary key,-- 自动增长列
   StuName varchar(20),
   Birthday Date,
   StuPhone  varchar(11)
)

insert into StuInfo(StuName,Birthday,StuPhone) values('张三',NOW(),'12345678911') -- 添加   SQLite获取系统时间datetime('now') 

select * from StuInfo -- 查询

 2、查询表的所有字段

select a.attname from pg_class as c,pg_attribute as a where c.relname='tablename' and a.attrelid=c.oid and a.attnum>0

 3、修改字段名

ALTER TABLE public.ss_db_table RENAME "DT_Name" TO dt_name;