Sample Header Ad - 728x90

postgres function definition not saving top whitespace

0 votes
1 answer
254 views
For reference I am running postgres 9.6 . I'd like to write functions inside of postgres where the top of the function saves. create or replace function apqp.apqp_list_gentex_tool_report_getlist(_omni_search text DEFAULT ''::text , _cust_id integer DEFAULT 0 ) returns TABLE(reason text , program text , mold_number text , rev text , stone_part_number text , part_description text , cust_request_num text , status text ) language sql as $$ -- and so on When I build this, if I relookup the function definition in datagrip the top part loses my white space I put in there and it looks like this. create or replace function apqp.apqp_list_gentex_tool_report_getlist(_omni_search text DEFAULT ''::text, _cust_id integer DEFAULT 0) returns TABLE(reason text, program text, mold_number text, rev text, stone_part_number text, part_description text, cust_request_num text, status text, kickoff date, mold_delivered date, first_shot date, ppap_submission_date date, interim_approval_expiration_date date, tool_shop text, manager text, apqp_status text, apqp_list_id integer, comments text) language sql as $$ Is there a setting in postgres or someway to save to the database when I CREATE a function that it will save my white space at the top. I'd like to be able to repull the definition while maintaining my white space.
Asked by Daniel L. VanDenBosch (408 rep)
Aug 7, 2019, 06:12 PM
Last activity: Aug 7, 2019, 11:49 PM