表

建表。

CREATE TABLE products (
    id INTEGER GENERATED ALWAYS AS IDENTITY PRIMARY KEY,
    name VARCHAR(100) NOT NULL,
    price MONEY NOT NULL,
    description TEXT NOT NULL
);

CREATA TABLE

查看表。

\dt

List of relations

Schema	Name	Type	Owner
public	products	table	postgres