SQL 基本操作

postgres=> select tdsqlc_version();
    tdsqlc_version    
----------------------
 TDSQLCPG v10.17-r1.2
(1 row)

postgres=# create table x(x1 int, x2 int);
CREATE TABLE

postgres=# insert into x values(1, 2);
INSERT 0 1

postgres=# update x set x1 = 1;
UPDATE 1

postgres=# create view v_x as select * from x;
CREATE VIEW

postgres=# select * from v_x;

 x1 | x2
——+——
  1 |  2
(1 row)

postgres=# select * from x;


 x1 | x2
——+——
  1 |  2
(1 row)

postgres=# CREATE TABLE test2 (
postgres(#   major int,
postgres(#   minor int,
postgres(#   name varchar
postgres(# );
CREATE TABLE

postgres=# CREATE INDEX test2_mm_idx ON test2 (major, minor);
CREATE INDEX

postgres=# CREATE INDEX test2_mm ON test2 (name);
CREATE INDEX

postgres=# CREATE INDEX test2_expr ON test2 ((major + minor));
CREATE INDEX