프로그래밍 공부/DB3 [PostgreSQL] ALTER TABLE https://www.postgresql.org/docs/9.1/sql-altertable.html ALTER TABLE ALTER TABLE Name ALTER TABLE -- change the definition of a table Synopsis ALTER TABLE [ ONLY ] name [ * ] action [, ... ] ALTER TABLE [ ONLY ] name [ * ] RENAME [ COLUMN ] column TO new_column ALTER TABLE name RENAME TO new_name ALTER TABLE name SET SCHE www.postgresql.org https://postgresql.kr/docs/11/sql-altertable.html ALTER .. 2021. 5. 24. [PostgreSQL] CTE https://www.postgresqltutorial.com/postgresql-cte/ PostgreSQL CTE Summary: in this tutorial, you will learn how to use the PostgreSQL CTE (common table expressions) to simplify complex queries. Introduction to PostgreSQL common table expressions or CTEs A common table expression is a temporary result set which you can re www.postgresqltutorial.com CTE :: Common Table Expression;공통 테이블 식 SELECT, .. 2021. 5. 24. [DB] DB Migration이란 https://life-with-coding.tistory.com/68 [DB] 데이터베이스 마이그레이션 1) 마이그레이션(migration) CRUD(Create, Read, Update, Delete)를 잘 수행하려면, 데이터 베이스 테이블 스키마가 잘 정의되어 있어야한다. 마이그레이션이란, 한 운영환경으로부터 다른 운영환. life-with-coding.tistory.com 2021. 5. 20. 이전 1 다음