PostgreSQL psql terminal command

Question

I m trying to get psql to format nicely and am following the docs here  Right now  whenever I do a query on tables with lots of columns  no matter how big I make my screen each line overflows into the next line and producing a whole screen of unreadable junk   The docs  link is above  say there s a way to align columns nicely for more readable output   Normally  to start psql  I just type      psql   and hit Enter  Now I m trying      psql  pset format aligned   And getting an error   could not change directory to   root  psql  warning  extra command-line argument  aligned  ingored psql  FATAL  Indent authentication failed for user  format    Any ideas as to how I could get these command-line args to work for me

User · Answer

psql --pset format FORMAT   Great for executing queries from command line  e g   psql --pset format unaligned -c  select bandanavalue from bandana where bandanakey    atlassian confluence settings

User · Answer

Use  x Example from postgres manual       postgres    x     postgres   SELECT   FROM pg stat statements ORDER BY total time DESC LIMIT 3      -  RECORD 1  ------------------------------------------------------------     userid       10     dbid         63781     query        UPDATE branches SET bbalance   bbalance    1 WHERE bid    2      calls        3000     total time   20 716706     rows         3000     -  RECORD 2  ------------------------------------------------------------     userid       10     dbid         63781     query        UPDATE tellers SET tbalance   tbalance    1 WHERE tid    2      calls        3000     total time   17 1107649999999     rows         3000     -  RECORD 3  ------------------------------------------------------------     userid       10     dbid         63781     query        UPDATE accounts SET abalance   abalance    1 WHERE aid    2      calls        3000     total time   0 645601     rows         3000

User · Answer

These are not command line args  Run psql  Manage to log into database  so pass the hostname  port  user and database if needed   And then write it in the psql program   Example  below are two commands  write the first one  press enter  wait for psql to login  write the second    psql -h host -p 5900 -U username database  pset format aligned

[linux] PostgreSQL psql terminal command

Examples related to linux

Examples related to postgresql

Examples related to command-line

Examples related to psql