Alternate Output Format For Psql


Answer :

I just needed to spend more time staring at the documentation. This command:

\x on

will do exactly what I wanted. Here is some sample output:

select * from dda where u_id=24 and dda_is_deleted='f'; -[ RECORD 1 ]------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- dda_id             | 1121 u_id               | 24 ab_id              | 10304 dda_type           | CHECKING dda_status         | PENDING_VERIFICATION dda_is_deleted     | f dda_verify_op_id   | 44938 version            | 2 created            | 2012-03-06 21:37:50.585845 modified           | 2012-03-06 21:37:50.593425 c_id               |  dda_nickname       |  dda_account_name   |  cu_id              | 1 abd_id             |

(New) Expanded Auto Mode: \x auto

New for Postgresql 9.2; PSQL automatically fits records to the width of the screen. previously you only had expanded mode on or off and had to switch between the modes as necessary.

  • If the record can fit into the width of the screen; psql uses normal formatting.
  • If the record can not fit into the width of the screen; psql uses expanded mode.

To get this use: \x auto

Postgresql 9.5 Documentation on PSQL command.

Wide screen, normal formatting:

 id | time  |       humanize_time             | value  ----+-------+---------------------------------+-------   1 | 09:30 |  Early Morning - (9.30 am)      |   570   2 | 11:30 |  Late Morning - (11.30 am)      |   690   3 | 13:30 |  Early Afternoon - (1.30pm)     |   810   4 | 15:30 |  Late Afternoon - (3.30 pm)     |   930 (4 rows)

Narrow screen, expanded formatting:

-[ RECORD 1 ]-+--------------------------- id            | 1 time          | 09:30 humanize_time | Early Morning - (9.30 am) value         | 570 -[ RECORD 2 ]-+--------------------------- id            | 2 time          | 11:30 humanize_time | Late Morning - (11.30 am) value         | 690 -[ RECORD 3 ]-+--------------------------- id            | 3 time          | 13:30 humanize_time | Early Afternoon - (1.30pm) value         | 810 -[ RECORD 4 ]-+--------------------------- id            | 4 time          | 15:30 humanize_time | Late Afternoon - (3.30 pm) value         | 930

How to start psql with \x auto?

Configure \x auto command on startup by adding it to .psqlrc in your home folder and restarting psql. Look under 'Files' section in the psql doc for more info.

~/.psqlrc

\x auto

You have so many choices, how could you be confused :-)? The main controls are: 

# \pset format # \H # \x # \pset pager off

Each has options and interactions with the others. The most automatic options are:

# \x off;\pset format wrapped # \x auto

The newer "\x auto" option switches to line-by-line display only "if needed".

-[ RECORD 1 ]--------------- id          | 6 description | This is a gallery of oilve oil brands. authority   | I love olive oil, and wanted to create a place for reviews and comments on various types. -[ RECORD 2 ]--------------- id          | 19 description | XXX Test A  authority   | Testing

The older "\pset format wrapped" is similar in that it tries to fit the data neatly on screen, but falls back to unaligned if the headers won't fit. Here's an example of wrapped: 

 id |          description           |            authority             ----+--------------------------------+---------------------------------   6 | This is a gallery of oilve     | I love olive oil, and wanted to     ; oil brands.                    ;  create a place for reviews and     ;                                ;  comments on various types.  19 | Test Test A                    | Testing

Comments

Post a Comment

Popular posts from this blog

Converting A String To Int In Groovy

Answer : Use the toInteger() method to convert a String to an Integer , e.g. int value = "99".toInteger() An alternative, which avoids using a deprecated method (see below) is int value = "66" as Integer If you need to check whether the String can be converted before performing the conversion, use String number = "66" if (number.isInteger()) { int value = number as Integer } Deprecation Update In recent versions of Groovy one of the toInteger() methods has been deprecated. The following is taken from org.codehaus.groovy.runtime.StringGroovyMethods in Groovy 2.4.4 /** * Parse a CharSequence into an Integer * * @param self a CharSequence * @return an Integer * @since 1.8.2 */ public static Integer toInteger(CharSequence self) { return Integer.valueOf(self.toString().trim()); } /** * @deprecated Use the CharSequence version * @see #toInteger(CharSequence) */ @Deprecated public static Integer toInteger(String self) { return toInteg
Read more

"Cannot Create Cache Directory /home//.composer/cache/repo/https---packagist.org/, Or Directory Is Not Writable. Proceeding Without Cache"

Answer : if anyone pass through here, this is shorter solution: sudo chown -R $USER $HOME/.composer it seems to me the group information is missing in your command sudo chown -R <user> /home/<user>/.composer/cache/repo/https---packagist.org Shoud be sudo chown -R <user>:<group> /home/<user>/.composer/cache/repo/https---packagist.org But to avoid other permission issues, I would rather advise: sudo chown -R <user>:<group> /home/<user>/.composer/cache (you'll need access to other folders in there) and sudo chown <user>:<group> /home/<user>/.composer To make sure your user has permissions enough on the global composer folder. Mind the missing recursion so the user don't own keys created by root. If you need to find out the group: groups <user>
Read more

Android How Can I Convert A String To A Editable

Answer : As you probably found out, Editable is an interface so you cannot call new Editable() . However an Editable is nothing more than a String with Spannables, so use SpannableStringBuilder: Editable editable = new SpannableStringBuilder("Pass a string here"); If you only want to change the Spannables, never the text itself, you can use a basic SpannableString. Use Editable.Factory.getInstance().newEditable(str) From the android documentation: Returns a new SpannedStringBuilder from the specified CharSequence. You can override this to provide a different kind of Spanned.
Read more