Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mBgXc-0000ID-NV for pgsql-hackers@arkaria.postgresql.org; Thu, 05 Aug 2021 16:48:20 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mBgXb-0002cw-61 for pgsql-hackers@arkaria.postgresql.org; Thu, 05 Aug 2021 16:48:19 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mBgXa-0002co-S5 for pgsql-hackers@lists.postgresql.org; Thu, 05 Aug 2021 16:48:18 +0000 Received: from mail-lf1-x133.google.com ([2a00:1450:4864:20::133]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1mBgXY-0003Mc-LR for pgsql-hackers@lists.postgresql.org; Thu, 05 Aug 2021 16:48:17 +0000 Received: by mail-lf1-x133.google.com with SMTP id z2so12414864lft.1 for ; Thu, 05 Aug 2021 09:48:16 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=subject:to:cc:references:from:message-id:date:user-agent :mime-version:in-reply-to:content-language:content-transfer-encoding; bh=n+ADYQ5sMzHVq6gQRWvXOV08hvXv1xApjLqyHDNLgOQ=; b=eFEJP++0bdh0gl0uZ81EseBDaHglB/gJCXVa69QY+BzqRg9yrUjRK5S+3PHL24nfs+ N0Cc9r+UUU9+h5hVAh2D1lLzIKc355+jhYaqJ7kwX9/+JhvOLOuIp3wPMxys4MO//Dt3 lfujMTzST3reCejuXEqCVqM1216OmReyW43veZkyQSTWHQhG8FFBVclMGppufyNECIyf ofdRbbJHSP5yS/ZHz4VHd8L94Q3e5vpYk9cmMJQS9dRhbLEgyPcEcdBFw58dgq/yTAGo nh0ag7S17G0tWEfn3wq5fWVvzXGdVutpYoC7ismJ0A58mOcGv5VE5r3rX2LW/8YxEpBK pVgQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:subject:to:cc:references:from:message-id:date :user-agent:mime-version:in-reply-to:content-language :content-transfer-encoding; bh=n+ADYQ5sMzHVq6gQRWvXOV08hvXv1xApjLqyHDNLgOQ=; b=umNUArrim/oabwjf5L/QfpWzU1J8OArY98IF644h3DMOzg3YptTB7OV570mc8S3Tz9 yDAcht0JrcovmJ1tSAdx3H0EEBMhQ4gdxQS+oil8oyMEKJe8N2/gonEr1iJZmg3g31sb e34uXFR/2MdI+WKQAfwhNTajnDe0KWM2RcH+VWdlnFnLA4VVEh24TQHBqT9EWD9NTQlu KzZkBCwQ+rctZaooxbg9AxRV/jvNHYq7IeF2eWzkl5CG/zgnIwco8+VpMgK7MXyFKTAG PoYewMH+RCVlt9OZMhafXJY1Un+/Z+fPWTJDZpC1+eZoGd/XEb1NtNlB3/0YrFpbmR82 bT0Q== X-Gm-Message-State: AOAM533EocsVfJSObrS49oevf4XZY8S2cYN8EZ2UsipNYPnQAw29rPy0 9r88CdgAzOHV+J3sd9Hy7/oDrTPePH0= X-Google-Smtp-Source: ABdhPJxIuvt43zsOB4AV4RQJlzkIrrodDQZTIUpztKhH2UYA9LhqeFHly4/Ia+3EJJAqzEVrSw+V1w== X-Received: by 2002:a05:6512:686:: with SMTP id t6mr4210681lfe.69.1628182094510; Thu, 05 Aug 2021 09:48:14 -0700 (PDT) Received: from [192.168.1.3] ([46.138.249.39]) by smtp.gmail.com with ESMTPSA id bu1sm561000lfb.306.2021.08.05.09.48.13 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Thu, 05 Aug 2021 09:48:14 -0700 (PDT) Subject: Re: very long record lines in expanded psql output To: Andrew Dunstan , Pavel Stehule Cc: PostgreSQL Hackers References: <998a8549-f808-a349-bae6-9f44d07e050d@dunslane.net> From: Platon Pronko Message-ID: <4e8b9a10-95aa-aecf-01a1-cbc24d643465@gmail.com> Date: Thu, 5 Aug 2021 19:48:13 +0300 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:78.0) Gecko/20100101 Thunderbird/78.12.0 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=utf-8; format=flowed Content-Language: en-US Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi! >>> I also find this annoying and would be happy to be rid of it. >> >> Have you tried "\pset format wrapped"? Pavel suggested it, and it >> solved most of the problem for me, for example. > > Yes, but it changes the data line output. Ideally, you should be able > to  modify these independently. I agree, and I think this can be implemented, but I'm a bit afraid of introducing an additional psql option (there's already quite a lot of them). I suspect primary PostgreSQL maintainers won't be happy with such an approach. Best regards, Platon Pronko