Hexo
0%

Postgres

Posted on Edited on

Init

  1. Install
    1
    brew install postgresql
  2. Initdb
    1
    initdb /usr/local/var/postgres
  3. Start
    1
    /usr/local/opt/postgresql/bin/postgres -D /usr/local/var/postgres

Update schema

  1. Alter column
    1
    alter table "table_v2" alter column "description" type text;