洪民憙 (Hong Minhee): PostgreSQL에서는 CTE에 INSERT/UPDATE/DELETE도 쓸 수 있구나. 그래서 동시에 2개 이상의 테이블에 삽입한다든가 하는 게 가능. 근데 내가 쓸 일이 있을까…? https://www.postgresql.org/docs/current/queries-with.html#QUERIES-WITH-MODIFYING

Hackers’ Pub

Syntax	Description	Examples
`"` keyword `"`	Finds the string within quotes, including spaces. Case-insensitive. (Escape quotes inside with `\"`)	`"Hackers' Pub"`
`from:` handle	Finds content written by the specified user.	`from:hongminhee` `from:hongminhee@hollo.social`
`lang:` ISO 639-1	Finds content written in the specified language.	`lang:en`
`#` tag	Finds content with the specified tag. Case-insensitive.	`#HackersPub`
condition condition	Finds content that satisfies both conditions on either side of the space (logical AND).	`"Hackers' Pub" lang:en`
condition `OR` condition	Finds content that satisfies at least one of the conditions on either side of the OR operator (logical OR).	`#HackersPub OR "Hackers' Pub" lang:en`
`(` condition `)`	Combines the operators within the parentheses first.	`(#HackersPub OR "Hackers' Pub" OR "Hackers Pub") lang:en`

洪民憙 (Hong Minhee) @hongminhee@hackers.pub

4/21/2025, 7:56:26 PM

Public

PostgreSQL에서는 CTE에 INSERT/UPDATE/DELETE도 쓸 수 있구나. 그래서 동시에 2개 이상의 테이블에 삽입한다든가 하는 게 가능. 근데 내가 쓸 일이 있을까…?

https://www.postgresql.org/docs/current/queries-with.html#QUERIES-WITH-MODIFYING

7.8. WITH Queries (Common Table Expressions)

7.8. WITH Queries (Common Table Expressions) # 7.8.1. SELECT in WITH 7.8.2. Recursive Queries 7.8.3. Common Table Expression Materialization 7.8.4. Data-Modifying …

www.postgresql.org · PostgreSQL Documentation

If you have a fediverse account, you can reply to this note from your own instance. Search https://hackers.pub/ap/notes/019659ec-6353-799e-ac12-856502acd572 on your instance and reply to it.