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
Last activity: Aug 7, 2019, 11:49 PM