SQL: postgres commands && others

postgres commands

• 好棒棒網站

timestamp

• Understanding PostgreSQL Timestamp Data Types

• 格式:

  • TIMESTAMPTZ: 2020-03-27 17:30:20+00

pq uuid rule

• doc
  • uuid_generate_v4()

Procedures and functions

• https://www.enterprisedb.com/postgres-tutorials/everything-you-need-know-about-postgres-stored-procedures-and-functions%C2%A0

PostgresSQL SELECT DISTINCT

• https://www.postgresqltutorial.com/postgresql-select-distinct/