Skip to content
loading...

re: SQL 201: Why you should use SQL CTEs VIEW POST

FULL DISCUSSION
 

Great article :)

A strategy I found useful was making views out of very scary looking queries / queries with rather involved business logic. It can be tested/debugged and then be used for querying without further worries. Also, Postgres's \dv makes it easy to list views.

code of conduct - report abuse