[PostgreSQL] Instagram DB
Instagram DB ```sql CREATE TABLE users ( id SERIAL PRIMARY KEY, created_at TIMESTAMP WITH TIME ZONE DEFAULT CURRENT_TIMESTAMP, updated_at TIMESTAMP WITH T...
Instagram DB ```sql CREATE TABLE users ( id SERIAL PRIMARY KEY, created_at TIMESTAMP WITH TIME ZONE DEFAULT CURRENT_TIMESTAMP, updated_at TIMESTAMP WITH T...
Polymorphic Association Definition Solution1 Solution2 Solution3
Data Types Data Types General Rule for Numeric Datetypes INTERVAL
GREATER & LEAST GREATER: returns the greatest value from the list LEAST: returns the least(smallest) value from the list
OFFSET 몇 번째 행 이후의 데이터를 보고 싶을 때 사용 LIMIT과 함께 사용시 관습적으로 LIMIT 뒤에 사용함