Re:Documenting your PostgreSQL database
by helge5 on Monday July 27, 2015 @06:56AM
(#9954426)
If it is worth commenting on, you might actually want to turn your SELECT into a VIEW:
CREATE VIEW "Names of projects with open tasks grouped by email"
AS SELECT users.email, array_to_string( ...;
COMMENT ON VIEW "Names of projects with open tasks grouped by email"
IS 'More info on query ...';
CREATE VIEW "Names of projects with open tasks grouped by email" AS SELECT users.email, array_to_string( ...; COMMENT ON VIEW "Names of projects with open tasks grouped by email" IS 'More info on query ...';