Greenplum小把戏 - select结果不带列名

为什么80%的码农都做不了架构师？>>>   

在业务处理数据库数据时，通常我们已经固定好表的格式并在程序中写好了需要的列名，所以在数据处理时，我们不需要像在psql中查看的那样带有结果列名。

在Greenplum、Deepgreen等PG生态体系中，我们可以通过在psql后面添加-t参数或者在数据库中设置\t on只让结果输出数据，而不显示列名，下面直接上例子。

默认显示列名：

[hgimdb@ps1 ~]$ psql -c "select * from hgimdbtab limit 5"
 lorderkey | lpartkey | lsuppkey | llinenumber | lquantity | lextendedprice | ldiscount | ltax  | lreturnflag | llinestatus | lshipd
ate  | lcommitdate | lreceiptdate | lshipinstruct | lshipmode | lcoment  | lid
-----------+----------+----------+-------------+-----------+----------------+-----------+-------+-------------+-------------+-------
-----+-------------+--------------+---------------+-----------+----------+-----
         7 |        7 |        7 |           7 |      7.00 |           7.00 |      7.00 |  7.00 | flag7       | status7     | 2019-0
1-03 | 2019-01-03  | 2019-01-03   | struct7       | mode7     | coment7  |   7
        15 |       15 |       15 |          15 |     15.00 |          15.00 |     15.00 | 15.00 | flag15      | status15    | 2019-0
1-03 | 2019-01-03  | 2019-01-03   | struct15      | mode15    | coment15 |  15
        23 |       23 |       23 |          23 |     23.00 |          23.00 |     23.00 | 23.00 | flag23      | status23    | 2019-0
1-03 | 2019-01-03  | 2019-01-03   | struct23      | mode23    | coment23 |  23
        31 |       31 |       31 |          31 |     31.00 |          31.00 |     31.00 | 31.00 | flag31      | status31    | 2019-0
1-03 | 2019-01-03  | 2019-01-03   | struct31      | mode31    | coment31 |  31
        39 |       39 |       39 |          39 |     39.00 |          39.00 |     39.00 | 39.00 | flag39      | status39    | 2019-0
1-03 | 2019-01-03  | 2019-01-03   | struct39      | mode39    | coment39 |  39
(5 rows)

postgres=# select * from hgimdbtab limit 5;
 lorderkey | lpartkey | lsuppkey | llinenumber | lquantity | lextendedprice | ldiscount | ltax  | lreturnflag | llinestatus | lshipd
ate  | lcommitdate | lreceiptdate | lshipinstruct | lshipmode | lcoment  | lid
-----------+----------+----------+-------------+-----------+----------------+-----------+-------+-------------+-------------+-------
-----+-------------+--------------+---------------+-----------+----------+-----
         3 |        3 |        3 |           3 |      3.00 |           3.00 |      3.00 |  3.00 | flag3       | status3     | 2019-0
1-03 | 2019-01-03  | 2019-01-03   | struct3       | mode3     | coment3  |   3
        11 |       11 |       11 |          11 |     11.00 |          11.00 |     11.00 | 11.00 | flag11      | status11    | 2019-0
1-03 | 2019-01-03  | 2019-01-03   | struct11      | mode11    | coment11 |  11
        19 |       19 |       19 |          19 |     19.00 |          19.00 |     19.00 | 19.00 | flag19      | status19    | 2019-0
1-03 | 2019-01-03  | 2019-01-03   | struct19      | mode19    | coment19 |  19
        27 |       27 |       27 |          27 |     27.00 |          27.00 |     27.00 | 27.00 | flag27      | status27    | 2019-0
1-03 | 2019-01-03  | 2019-01-03   | struct27      | mode27    | coment27 |  27
        35 |       35 |       35 |          35 |     35.00 |          35.00 |     35.00 | 35.00 | flag35      | status35    | 2019-0
1-03 | 2019-01-03  | 2019-01-03   | struct35      | mode35    | coment35 |  35
(5 rows)

设置后不显示列名：

postgres=# \t on
Showing only tuples.
postgres=# select * from hgimdbtab limit 5;
         8 |        8 |        8 |           8 |      8.00 |           8.00 |      8.00 |  8.00 | flag8       | status8     | 2019-0
1-03 | 2019-01-03  | 2019-01-03   | struct8       | mode8     | coment8  |   8
        16 |       16 |       16 |          16 |     16.00 |          16.00 |     16.00 | 16.00 | flag16      | status16    | 2019-0
1-03 | 2019-01-03  | 2019-01-03   | struct16      | mode16    | coment16 |  16
        24 |       24 |       24 |          24 |     24.00 |          24.00 |     24.00 | 24.00 | flag24      | status24    | 2019-0
1-03 | 2019-01-03  | 2019-01-03   | struct24      | mode24    | coment24 |  24
        32 |       32 |       32 |          32 |     32.00 |          32.00 |     32.00 | 32.00 | flag32      | status32    | 2019-0
1-03 | 2019-01-03  | 2019-01-03   | struct32      | mode32    | coment32 |  32
        40 |       40 |       40 |          40 |     40.00 |          40.00 |     40.00 | 40.00 | flag40      | status40    | 2019-0
1-03 | 2019-01-03  | 2019-01-03   | struct40      | mode40    | coment40 |  40

[hgimdb@ps1 ~]$ psql -c "select * from hgimdbtab limit 5" -t
         3 |        3 |        3 |           3 |      3.00 |           3.00 |      3.00 |  3.00 | flag3       | status3     | 2019-0
1-03 | 2019-01-03  | 2019-01-03   | struct3       | mode3     | coment3  |   3
        11 |       11 |       11 |          11 |     11.00 |          11.00 |     11.00 | 11.00 | flag11      | status11    | 2019-0
1-03 | 2019-01-03  | 2019-01-03   | struct11      | mode11    | coment11 |  11
        19 |       19 |       19 |          19 |     19.00 |          19.00 |     19.00 | 19.00 | flag19      | status19    | 2019-0
1-03 | 2019-01-03  | 2019-01-03   | struct19      | mode19    | coment19 |  19
        27 |       27 |       27 |          27 |     27.00 |          27.00 |     27.00 | 27.00 | flag27      | status27    | 2019-0
1-03 | 2019-01-03  | 2019-01-03   | struct27      | mode27    | coment27 |  27
        35 |       35 |       35 |          35 |     35.00 |          35.00 |     35.00 | 35.00 | flag35      | status35    | 2019-0
1-03 | 2019-01-03  | 2019-01-03   | struct35      | mode35    | coment35 |  35

 

转载于:https://my.oschina.net/javacy/blog/2997395