now seems you cannot limit number of chars per line?

[jianhe-fun]

can you set the limits then the remaining line expand to the next line?

[darold]

Please post an example, I'm not sure to understand what you mean.

[jianhe-fun]

CREATE OR REPLACE FUNCTION create_post (uid_query text, post_text_query text DEFAULT '', text_url_query text DEFAULT '', photo_url_query text DEFAULT '', video_url_query text DEFAULT '', audio_url_query text DEFAULT '', location_query text DEFAULT '', tags_array_query text[] DEFAULT '{general}', photo_query bool DEFAULT FALSE, out post_insert_id int)
    RETURNS integer
    LANGUAGE plpgsql
    AS $func$

as you can see, first line is far too long.

[jianhe-fun]

set the line textwidth limit.

[darold]

If you use the --wrap-limit it works fine:

 perl pg_format a.sql -w 80
CREATE OR REPLACE FUNCTION create_post (uid_query text, post_text_query text
    DEFAULT '', text_url_query text DEFAULT '', photo_url_query text DEFAULT '', video_url_query text DEFAULT '',
    audio_url_query text DEFAULT '', location_query text DEFAULT '', tags_array_query text[] DEFAULT
    '{general}', photo_query bool DEFAULT FALSE, out post_insert_id int)
    RETURNS integer
    LANGUAGE plpgsql
    AS $func$

but as you don't provide your pg_format command line I guess that this is not what you are using.