0
0

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?

More than 3 years have passed since last update.

SELECT文の結果を見やすくする

Last updated at Posted at 2022-03-30

使用用途

SELECT文を流した際に、結果が多くて見ずらい時に結果を見やすくする

使用方法

①SELECT文の最後を  ; ではなく \G にする

例文
SELECT * from tableName \G

pager less -S を使用する

-Sはlessのオプションで改行をしないという意味

例文
pager less -S
SELECT * from tableName;

pagerを閉じる場合は q
解除するには nopagerexit
 
 
 
この記事は以下の情報を参考にして執筆しました。

0
0
0

Register as a new user and use Qiita more conveniently

  1. You get articles that match your needs
  2. You can efficiently read back useful information
  3. You can use dark theme
What you can do with signing up
0
0

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?