Underground pipe network longitudinal section analysis method realized based on POSTGRESQL

The invention discloses an underground pipe network longitudinal section analysis method based on POSTGRESQL. The underground pipe network longitudinal section analysis method comprises the following steps: step 1, inputting a pipeline table name and serial numbers of two sections of pipelines to be queried; step 2, querying the number of two pipeline numbers in the pipeline table by sql, entering step 3 if the number is equal to 2, and exiting and returning an empty record if the number is not equal to 2; step 3, judging whether the two pipe sections are adjacent according to the starting and ending point numbers, entering step 4 if the two pipe sections are adjacent, and entering step 5 if the two pipe sections are not adjacent; 4, querying the serial numbers of two pipe sections, the length of the pipe sections, the horizontal projection distance and other attribute information in the table in the sql query pipeline table, and returning; and step 5, querying all through paths from the starting pipe section