Avatar of mikeysmailbox1
mikeysmailbox1
 asked on

Postgresql SQL output set column width

Hi

I have some SQL that when it outputs to a file I need to have it set the column to a shorter width.


select app, note, message from abc


output is currently

app                         note                                     message
-----------------------    -----------------------------         ------------------------------------
aaksssjjdjddjdjd    dsssss sssssd ddddd        my message is this long



But needs to be

app                note               message
--------             ------------         ---------------
aakss             dsssss s         my messa


Not sure there is a way to limit the column width on output from psql


Thanks

Mike
PostgreSQL

Avatar of undefined
Last Comment
mikeysmailbox1

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
earth man2

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
earth man2

Anything we can help you with ?
mikeysmailbox1

ASKER
Worked great
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23