{"id":27378,"date":"2023-05-12T11:43:14","date_gmt":"2023-10-08T21:11:48","guid":{"rendered":"https:\/\/www.silicloud.com\/zh\/blog\/centos-%e4%b8%8a%e7%9a%84-postgresql-2\/"},"modified":"2025-08-12T02:22:11","modified_gmt":"2025-08-11T18:22:11","slug":"centos-%e4%b8%8a%e7%9a%84-postgresql-2","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/zh\/blog\/centos-%e4%b8%8a%e7%9a%84-postgresql-2\/","title":{"rendered":"CentOS \u4e0a\u7684 PostgreSQL"},"content":{"rendered":"
@<\/span>name<\/span>,<\/span> age<\/span>,<\/span> age<\/span>+<\/span>10<\/span>\u8868\u793a\u3001<\/span>20<\/span>\u4ee3\u4eba\u3060\u3051\u63a2\u3059\u306e\u6761\u4ef6<\/span>\r\npostgres<\/span>=#<\/span> select<\/span> name<\/span>,<\/span> age<\/span>,<\/span> age<\/span>+<\/span>10<\/span> \r\n          from<\/span> userlist<\/span> \r\n              where<\/span> age<\/span> between<\/span> 20<\/span> and<\/span> 30<\/span> \r\n;<\/span>\r\n  name<\/span>   |<\/span> age<\/span> |<\/span> ?<\/span>column<\/span>?<\/span>\r\n---------+-----+----------<\/span>\r\n nao<\/span>     |<\/span>  22<\/span> |<\/span>       32<\/span>\r\n lisa<\/span>    |<\/span>  24<\/span> |<\/span>       34<\/span>\r\n bob<\/span>     |<\/span>  23<\/span> |<\/span>       33<\/span>\r\n mary<\/span>    |<\/span>  25<\/span> |<\/span>       35<\/span>\r\n linda<\/span>   |<\/span>  26<\/span> |<\/span>       36<\/span>\r\n saori<\/span>   |<\/span>  21<\/span> |<\/span>       31<\/span>\r\n yuki<\/span>    |<\/span>  20<\/span> |<\/span>       30<\/span>\r\n yusuke<\/span>  |<\/span>  22<\/span> |<\/span>       32<\/span>\r\n mari<\/span>    |<\/span>  20<\/span> |<\/span>       30<\/span>\r\n yasuko<\/span>  |<\/span>  28<\/span> |<\/span>       38<\/span>\r\n hana<\/span>    |<\/span>  22<\/span> |<\/span>       32<\/span>\r\n asa<\/span>     |<\/span>  25<\/span> |<\/span>       35<\/span>\r\n chan<\/span>    |<\/span>  28<\/span> |<\/span>       38<\/span>\r\n toshi<\/span>   |<\/span>  22<\/span> |<\/span>       32<\/span>\r\n lulu<\/span>    |<\/span>  26<\/span> |<\/span>       36<\/span>\r\n dore<\/span>    |<\/span>  28<\/span> |<\/span>       38<\/span>\r\n mishima<\/span> |<\/span>  25<\/span> |<\/span>       35<\/span>\r\n osu<\/span>     |<\/span>  22<\/span> |<\/span>       32<\/span>\r\n sati<\/span>    |<\/span>  25<\/span> |<\/span>       35<\/span>\r\n kiriko<\/span>  |<\/span>  27<\/span> |<\/span>       37<\/span>\r\n(<\/span>20<\/span> rows<\/span>)<\/span>\r\n<\/code><\/pre>\n
@<\/span>\u3000<\/span>as<\/span>\r\npostgres<\/span>=#<\/span> select<\/span> name<\/span>,<\/span> age<\/span>,<\/span> \r\n                 age<\/span>+<\/span>10<\/span> as<\/span> \"in 10 years\"<\/span>\r\n                     from<\/span> userlist<\/span> \r\n                         where<\/span> age<\/span> between<\/span> 20<\/span> and<\/span> 30<\/span> \r\n\r\n;<\/span>\r\n  name<\/span>   |<\/span> age<\/span> |<\/span> in<\/span> 10<\/span> years<\/span>\r\n---------+-----+-------------<\/span>\r\n nao<\/span>     |<\/span>  22<\/span> |<\/span>          32<\/span>\r\n lisa<\/span>    |<\/span>  24<\/span> |<\/span>          34<\/span>\r\n bob<\/span>     |<\/span>  23<\/span> |<\/span>          33<\/span>\r\n mary<\/span>    |<\/span>  25<\/span> |<\/span>          35<\/span>\r\n linda<\/span>   |<\/span>  26<\/span> |<\/span>          36<\/span>\r\n saori<\/span>   |<\/span>  21<\/span> |<\/span>          31<\/span>\r\n yuki<\/span>    |<\/span>  20<\/span> |<\/span>          30<\/span>\r\n yusuke<\/span>  |<\/span>  22<\/span> |<\/span>          32<\/span>\r\n mari<\/span>    |<\/span>  20<\/span> |<\/span>          30<\/span>\r\n yasuko<\/span>  |<\/span>  28<\/span> |<\/span>          38<\/span>\r\n hana<\/span>    |<\/span>  22<\/span> |<\/span>          32<\/span>\r\n asa<\/span>     |<\/span>  25<\/span> |<\/span>          35<\/span>\r\n chan<\/span>    |<\/span>  28<\/span> |<\/span>          38<\/span>\r\n toshi<\/span>   |<\/span>  22<\/span> |<\/span>          32<\/span>\r\n lulu<\/span>    |<\/span>  26<\/span> |<\/span>          36<\/span>\r\n dore<\/span>    |<\/span>  28<\/span> |<\/span>          38<\/span>\r\n mishima<\/span> |<\/span>  25<\/span> |<\/span>          35<\/span>\r\n osu<\/span>     |<\/span>  22<\/span> |<\/span>          32<\/span>\r\n sati<\/span>    |<\/span>  25<\/span> |<\/span>          35<\/span>\r\n kiriko<\/span>  |<\/span>  27<\/span> |<\/span>          37<\/span>\r\n(<\/span>20<\/span> rows<\/span>)<\/span>\r\n<\/code><\/pre>\n
@<\/span>\u91cd\u8907\u306a\u3057<\/span>\r\npostgres<\/span>=#<\/span> select<\/span> distinct<\/span> address<\/span> from<\/span> userlist<\/span> ;<\/span>\r\n\r\n address<\/span>\r\n---------<\/span>\r\n kyoto<\/span>\r\n nagoya<\/span>\r\n paris<\/span>\r\n tokyo<\/span>\r\n fuhuoka<\/span>\r\n newyork<\/span>\r\n(<\/span>6<\/span> rows<\/span>)<\/span>\r\n<\/code><\/pre>\n
@<\/span>where<\/span> not<\/span> \u6587\u3000<\/span>20<\/span>\u53f0\u306b\u542b\u3081\u306a\u3044<\/span>\r\npostgres<\/span>=#<\/span> select<\/span> *<\/span> from<\/span> userlist<\/span> \r\n               where<\/span> \r\n                  not<\/span> age<\/span> >=<\/span> 20<\/span>\r\n;<\/span>\r\n\r\n id<\/span> |<\/span>  name<\/span>   |<\/span> address<\/span> |<\/span> age<\/span>\r\n----+---------+---------+-----<\/span>\r\n  1<\/span> |<\/span> sato<\/span>    |<\/span> tokyo<\/span>   |<\/span>  18<\/span>\r\n  5<\/span> |<\/span> kaoru<\/span>   |<\/span> nagoya<\/span>  |<\/span>  15<\/span>\r\n 12<\/span> |<\/span> takashi<\/span> |<\/span> fuhuoka<\/span> |<\/span>  19<\/span>\r\n 18<\/span> |<\/span> nori<\/span>    |<\/span> tokyo<\/span>   |<\/span>  19<\/span>\r\n 29<\/span> |<\/span> misa<\/span>    |<\/span> newyork<\/span> |<\/span>  18<\/span>\r\n 39<\/span> |<\/span> lyly<\/span>    |<\/span> fuhuoka<\/span> |<\/span>  19<\/span>\r\n(<\/span>6<\/span> rows<\/span>)<\/span>\r\n<\/code><\/pre>\n
@<\/span>20<\/span>\u6b73\u4ee5\u4e0a\u306e\u4eba\u3092\u691c\u7d22\u3059\u308b<\/span>\r\npostgres<\/span>=#<\/span> select<\/span> *<\/span> from<\/span> userlist<\/span>\r\n                            where<\/span> age<\/span> >=<\/span>20<\/span>\r\n;<\/span>\r\n id<\/span> |<\/span> name<\/span> |<\/span> address<\/span> |<\/span> age<\/span>\r\n----+------+---------+-----<\/span>\r\n  2<\/span> |<\/span> nao<\/span>  |<\/span> kyoto<\/span>   |<\/span>  22<\/span>\r\n  3<\/span> |<\/span> john<\/span> |<\/span> newyork<\/span> |<\/span>  34<\/span>\r\n  4<\/span> |<\/span> lisa<\/span> |<\/span> paris<\/span>   |<\/span>  24<\/span>\r\n  6<\/span> |<\/span> ryo<\/span>  |<\/span> fuhuoka<\/span> |<\/span>  40<\/span>\r\n\r\n\r\n@<\/span>20<\/span>\u6b73<\/span>~<\/span>25<\/span>\u6b73\u9593\u306e\u4eba\u3092\u691c\u7d22\u3059\u308b<\/span>\r\npostgres<\/span>=#<\/span> select<\/span> *<\/span> from<\/span> userlist<\/span> \r\n                 where<\/span> age<\/span> between<\/span> 20<\/span> and<\/span> 25<\/span>\r\n;<\/span>\r\n\r\n id<\/span> |<\/span> name<\/span> |<\/span> address<\/span> |<\/span> age<\/span>\r\n----+------+---------+-----<\/span>\r\n  2<\/span> |<\/span> nao<\/span>  |<\/span> kyoto<\/span>   |<\/span>  22<\/span>\r\n  4<\/span> |<\/span> lisa<\/span> |<\/span> paris<\/span>   |<\/span>  24<\/span>\r\n<\/code><\/pre>\n
@<\/span>where<\/span> \u6761\u4ef6\u6587\u3000<\/span>tokyo<\/span>\u306b\u4f4f\u3093\u3067\u308b\u4eba\u3060\u3051\u63a2\u3059<\/span>\r\nselect<\/span> *<\/span> from<\/span> userlist<\/span> \r\n         where<\/span> address<\/span> =<\/span> `tokyo`<\/span> \r\n;<\/span>\r\n id<\/span> |<\/span>  name<\/span>   |<\/span> address<\/span> |<\/span> age<\/span>\r\n----+---------+---------+-----<\/span>\r\n  1<\/span> |<\/span> sato<\/span>    |<\/span> tokyo<\/span>   |<\/span>  18<\/span>\r\n  7<\/span> |<\/span> bob<\/span>     |<\/span> tokyo<\/span>   |<\/span>  23<\/span>\r\n 11<\/span> |<\/span> yosuke<\/span>  |<\/span> tokyo<\/span>   |<\/span>  41<\/span>\r\n 16<\/span> |<\/span> take<\/span>    |<\/span> tokyo<\/span>   |<\/span>  36<\/span>\r\n 18<\/span> |<\/span> nori<\/span>    |<\/span> tokyo<\/span>   |<\/span>  19<\/span>\r\n 21<\/span> |<\/span> jun<\/span>     |<\/span> tokyo<\/span>   |<\/span>  34<\/span>\r\n 24<\/span> |<\/span> hana<\/span>    |<\/span> tokyo<\/span>   |<\/span>  22<\/span>\r\n 27<\/span> |<\/span> kyoko<\/span>   |<\/span> tokyo<\/span>   |<\/span>  34<\/span>\r\n 31<\/span> |<\/span> reiko<\/span>   |<\/span> tokyo<\/span>   |<\/span>  32<\/span>\r\n 33<\/span> |<\/span> lulu<\/span>    |<\/span> tokyo<\/span>   |<\/span>  26<\/span>\r\n 34<\/span> |<\/span> panda<\/span>   |<\/span> tokyo<\/span>   |<\/span>  35<\/span>\r\n 36<\/span> |<\/span> zuke<\/span>    |<\/span> tokyo<\/span>   |<\/span>  33<\/span>\r\n 38<\/span> |<\/span> mishima<\/span> |<\/span> tokyo<\/span>   |<\/span>  25<\/span>\r\n 41<\/span> |<\/span> sati<\/span>    |<\/span> tokyo<\/span>   |<\/span>  25<\/span>\r\n(<\/span>14<\/span> rows<\/span>)<\/span>\r\n<\/code><\/pre>\n
@<\/span>and<\/span> -<\/span> \u6761\u4ef6\u6587\u3092\u8907\u6570\u306b\u4f7f\u3048\u308b<\/span>\r\npostgres<\/span>=#<\/span> select<\/span> *<\/span> from<\/span> userlist<\/span> \r\n             where<\/span> not<\/span> age<\/span> >=<\/span> 20<\/span> and<\/span> not<\/span> address<\/span> =<\/span> 'tokyo'<\/span> \r\n;<\/span>\r\n id<\/span> |<\/span>  name<\/span>   |<\/span> address<\/span> |<\/span> age<\/span>\r\n----+---------+---------+-----<\/span>\r\n  5<\/span> |<\/span> kaoru<\/span>   |<\/span> nagoya<\/span>  |<\/span>  15<\/span>\r\n 12<\/span> |<\/span> takashi<\/span> |<\/span> fuhuoka<\/span> |<\/span>  19<\/span>\r\n 29<\/span> |<\/span> misa<\/span>    |<\/span> newyork<\/span> |<\/span>  18<\/span>\r\n 39<\/span> |<\/span> lyly<\/span>    |<\/span> fuhuoka<\/span> |<\/span>  19<\/span>\r\n(<\/span>4<\/span> rows<\/span>)<\/span>\r\n<\/code><\/pre>\n
@<\/span>or<\/span>\u6587<\/span>\r\npostgres<\/span>=#<\/span> select<\/span> *<\/span> from<\/span> userlist<\/span> \r\n               where<\/span> age<\/span> >=<\/span> 20<\/span> or<\/span> address<\/span> =<\/span> 'tokyo'<\/span> \r\n;<\/span>\r\n\r\n id<\/span> |<\/span>  name<\/span>   |<\/span> address<\/span> |<\/span> age<\/span>\r\n----+---------+---------+-----<\/span>\r\n  1<\/span> |<\/span> sato<\/span>    |<\/span> tokyo<\/span>   |<\/span>  18<\/span>\r\n  2<\/span> |<\/span> nao<\/span>     |<\/span> kyoto<\/span>   |<\/span>  22<\/span>\r\n  3<\/span> |<\/span> john<\/span>    |<\/span> newyork<\/span> |<\/span>  34<\/span>\r\n  4<\/span> |<\/span> lisa<\/span>    |<\/span> paris<\/span>   |<\/span>  24<\/span>\r\n  6<\/span> |<\/span> ryo<\/span>     |<\/span> fuhuoka<\/span> |<\/span>  40<\/span>\r\n  7<\/span> |<\/span> bob<\/span>     |<\/span> tokyo<\/span>   |<\/span>  23<\/span>\r\n  8<\/span> |<\/span> jack<\/span>    |<\/span> kyoto<\/span>   |<\/span>  35<\/span>\r\n  9<\/span> |<\/span> mary<\/span>    |<\/span> newyork<\/span> |<\/span>  25<\/span>\r\n 10<\/span> |<\/span> linda<\/span>   |<\/span> paris<\/span>   |<\/span>  26<\/span>\r\n 11<\/span> |<\/span> yosuke<\/span>  |<\/span> tokyo<\/span>   |<\/span>  41<\/span>\r\n 13<\/span> |<\/span> saori<\/span>   |<\/span> kyoto<\/span>   |<\/span>  21<\/span>\r\n 14<\/span> |<\/span> yuki<\/span>    |<\/span> paris<\/span>   |<\/span>  20<\/span>\r\n 15<\/span> |<\/span> tomo<\/span>    |<\/span> newyork<\/span> |<\/span>  31<\/span>\r\n 16<\/span> |<\/span> take<\/span>    |<\/span> tokyo<\/span>   |<\/span>  36<\/span>\r\n 17<\/span> |<\/span> yusuke<\/span>  |<\/span> nagoya<\/span>  |<\/span>  22<\/span>\r\n 18<\/span> |<\/span> nori<\/span>    |<\/span> tokyo<\/span>   |<\/span>  19<\/span>\r\n 19<\/span> |<\/span> mari<\/span>    |<\/span> newyork<\/span> |<\/span>  20<\/span>\r\n 20<\/span> |<\/span> sachi<\/span>   |<\/span> nagoya<\/span>  |<\/span>  36<\/span>\r\n 21<\/span> |<\/span> jun<\/span>     |<\/span> tokyo<\/span>   |<\/span>  34<\/span>\r\n 22<\/span> |<\/span> yasuko<\/span>  |<\/span> nagoya<\/span>  |<\/span>  28<\/span>\r\n 23<\/span> |<\/span> reo<\/span>     |<\/span> nagoya<\/span>  |<\/span>  33<\/span>\r\n<\/code><\/pre>\n
@<\/span>count<\/span> -<\/span> \u4f55\u6570\u304b\u3001<\/span>check<\/span>\u3067\u304d\u308b<\/span>\r\npostgres<\/span>=#<\/span> select<\/span> count<\/span>(<\/span>*<\/span>)<\/span>from<\/span> userlist<\/span> \r\n                  where<\/span> age<\/span> >=<\/span>20<\/span> \r\n;<\/span>\r\n count<\/span>\r\n-------<\/span>\r\n    36<\/span>\r\n(<\/span>1<\/span> row<\/span>)<\/span>\r\n\r\npostgres<\/span>=#<\/span> select<\/span> count<\/span>(<\/span>*<\/span>)<\/span>from<\/span> userlist<\/span>\r\n                  where<\/span> address<\/span> =<\/span> 'tokyo'<\/span> \r\n;<\/span>\r\n\r\n\r\n count<\/span>\r\n-------<\/span>\r\n    14<\/span>\r\n(<\/span>1<\/span> row<\/span>)<\/span>\r\n\r\npostgres<\/span>=#<\/span> select<\/span> count<\/span>(<\/span>*<\/span>)<\/span>from<\/span> userlist<\/span> \r\n                where<\/span> age<\/span> between<\/span> 20<\/span> and<\/span> 30<\/span> \r\n;<\/span>\r\n\r\n count<\/span>\r\n-------<\/span>\r\n    20<\/span>\r\n(<\/span>1<\/span> row<\/span>)<\/span>\r\n<\/code><\/pre>\n
@<\/span>group<\/span> by<\/span> -<\/span> \u5b9f\u884c\u3057\u305f\u7d50\u679c\u3092\u30b0\u30eb\u30fc\u30d7\u5316\u3059\u308b<\/span>\r\npostgres<\/span>=#<\/span> select<\/span> address<\/span> ,<\/span> count<\/span> (<\/span>*<\/span>)<\/span> from<\/span> userlist<\/span> \r\n                    group<\/span> by<\/span> address<\/span> \r\n;<\/span>\r\n address<\/span> |<\/span> count<\/span>\r\n---------+-------<\/span>\r\n kyoto<\/span>   |<\/span>     3<\/span>\r\n nagoya<\/span>  |<\/span>     5<\/span>\r\n paris<\/span>   |<\/span>     7<\/span>\r\n tokyo<\/span>   |<\/span>    14<\/span>\r\n fuhuoka<\/span> |<\/span>     5<\/span>\r\n newyork<\/span> |<\/span>     8<\/span>\r\n(<\/span>6<\/span> rows<\/span>)<\/span>\r\n<\/code><\/pre>\n
@<\/span>\u540d\u524d\u3092\u5909\u3048\u308b\u3068\u304d<\/span>\r\npostgres<\/span>=#<\/span> select<\/span> \r\n              address<\/span> as<\/span> \"area\"<\/span> from<\/span> userlist<\/span> \r\n;<\/span>\r\n  area<\/span>\r\n---------<\/span>\r\n tokyo<\/span>\r\n kyoto<\/span>\r\n newyork<\/span>\r\n paris<\/span>\r\n nagoya<\/span>\r\n fuhuoka<\/span>\r\n tokyo<\/span>\r\n kyoto<\/span>\r\n newyork<\/span>\r\n paris<\/span>\r\n tokyo<\/span>\r\n fuhuoka<\/span>\r\n kyoto<\/span>\r\n paris<\/span>\r\n newyork<\/span>\r\n tokyo<\/span>\r\n nagoya<\/span>\r\n tokyo<\/span>\r\n newyork<\/span>\r\n nagoya<\/span>\r\n tokyo<\/span>\r\n<\/code><\/pre>\n
@<\/span>address<\/span> -><\/span> as<\/span> list<\/span>\u540d\u524d\u3092\u5909\u66f4\u3057\u3066\u898b\u305b\u308b<\/span>\r\npostgres<\/span>=#<\/span> select<\/span> \r\n              address<\/span> as<\/span> \"area\"<\/span>,<\/span> \r\n                   count<\/span> (<\/span>*<\/span>)<\/span> from<\/span> userlist<\/span> \r\n                       group<\/span> by<\/span> address<\/span> \r\n;<\/span>\r\n\r\n  area<\/span>   |<\/span> count<\/span>\r\n---------+-------<\/span>\r\n kyoto<\/span>   |<\/span>     3<\/span>\r\n nagoya<\/span>  |<\/span>     5<\/span>\r\n paris<\/span>   |<\/span>     7<\/span>\r\n tokyo<\/span>   |<\/span>    14<\/span>\r\n fuhuoka<\/span> |<\/span>     5<\/span>\r\n newyork<\/span> |<\/span>     8<\/span>\r\n(<\/span>6<\/span> rows<\/span>)<\/span>\r\n<\/code><\/pre>\n
@<\/span>\u30e6\u30fc\u30b6\u30ea\u30b9\u30c8\u306e\u5e73\u5747\u5e74\u9f62\u3092\u78ba\u8a8d\u3059\u308b<\/span>\r\npostgres<\/span>=#<\/span> select<\/span> avg<\/span>(<\/span>age<\/span>)<\/span>from<\/span> userlist<\/span>;<\/span>\r\n         avg<\/span>\r\n---------------------<\/span>\r\n 25<\/span>.<\/span>5000000000000000<\/span>\r\n(<\/span>1<\/span> row<\/span>)<\/span>\r\n\r\n@<\/span>\u30e6\u30fc\u30b6\u30ea\u30b9\u30c8\u306e\u5e74\u9f62\u5408\u8a08\u3092\u78ba\u8a8d\u3059\u308b<\/span>\r\npostgres<\/span>=#<\/span> select<\/span> sum<\/span>(<\/span>age<\/span>)<\/span>from<\/span> userlist<\/span>;<\/span>\r\n sum<\/span>\r\n-----<\/span>\r\n 153<\/span>\r\n<\/code><\/pre>\n
postgres<\/span>=#<\/span> select<\/span> address<\/span>,<\/span> max<\/span>(<\/span>age<\/span>),<\/span> min<\/span>(<\/span>age<\/span>),<\/span> avg<\/span>(<\/span>age<\/span>),<\/span> sum<\/span>(<\/span>age<\/span>),<\/span> count<\/span>(<\/span>*<\/span>)<\/span> from<\/span> userlist<\/span> \r\n                group<\/span> by<\/span> address<\/span> \r\n;<\/span>\r\n address<\/span> |<\/span> max<\/span> |<\/span> min<\/span> |<\/span>         avg<\/span>         |<\/span> sum<\/span> |<\/span> count<\/span>\r\n---------+-----+-----+---------------------+-----+-------<\/span>\r\n kyoto<\/span>   |<\/span>  35<\/span> |<\/span>  21<\/span> |<\/span> 26<\/span>.<\/span>0000000000000000<\/span> |<\/span>  78<\/span> |<\/span>     3<\/span>\r\n nagoya<\/span>  |<\/span>  36<\/span> |<\/span>  15<\/span> |<\/span> 26<\/span>.<\/span>8000000000000000<\/span> |<\/span> 134<\/span> |<\/span>     5<\/span>\r\n paris<\/span>   |<\/span>  36<\/span> |<\/span>  20<\/span> |<\/span> 26<\/span>.<\/span>2857142857142857<\/span> |<\/span> 184<\/span> |<\/span>     7<\/span>\r\n tokyo<\/span>   |<\/span>  41<\/span> |<\/span>  18<\/span> |<\/span> 28<\/span>.<\/span>7857142857142857<\/span> |<\/span> 403<\/span> |<\/span>    14<\/span>\r\n fuhuoka<\/span> |<\/span>  40<\/span> |<\/span>  19<\/span> |<\/span> 28<\/span>.<\/span>0000000000000000<\/span> |<\/span> 140<\/span> |<\/span>     5<\/span>\r\n newyork<\/span> |<\/span>  34<\/span> |<\/span>  18<\/span> |<\/span> 25<\/span>.<\/span>8750000000000000<\/span> |<\/span> 207<\/span> |<\/span>     8<\/span>\r\n(<\/span>6<\/span> rows<\/span>)<\/span>\r\n<\/code><\/pre>\n
\r\n@<\/span>db<\/span>\u306e<\/span>table<\/span>\u524a\u9664<\/span>\r\npostgres<\/span>=#<\/span> drop<\/span> table<\/span> userlist<\/span>\r\n;<\/span>\r\n\r\n@<\/span>sales<\/span>\u3068\u8a00\u3046\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u524a\u9664<\/span>\r\npostgres<\/span>=#<\/span> drop<\/span> database<\/span> sales<\/span>\r\n;<\/span>\r\nDROP<\/span> DATABASE<\/span>\r\n<\/code><\/pre>\n
@<\/span>postgreSQL<\/span>\u7d42\u4e86<\/span>\r\npostgres<\/span>=#<\/span> \\<\/span>q<\/span>\r\n\r\n<\/code><\/pre>\n
\r\n@<\/span>\u5e74\u4e0b\u306e\u4eba\u304b\u3089\u6574\u5217\u3059\u308b<\/span>\r\npostgres<\/span>=#<\/span> select<\/span> *<\/span> from<\/span> userlist<\/span> \r\n               order<\/span> by<\/span> age<\/span>\r\n;<\/span>\r\n\r\n id<\/span> |<\/span> name<\/span> |<\/span> address<\/span> |<\/span> age<\/span>\r\n----+------+---------+-----<\/span>\r\n  5<\/span> |<\/span> ryo<\/span>  |<\/span> newyork<\/span> |<\/span>  15<\/span>\r\n  1<\/span> |<\/span> sato<\/span> |<\/span> tokyo<\/span>   |<\/span>  18<\/span>\r\n  2<\/span> |<\/span> nao<\/span>  |<\/span> kyoto<\/span>   |<\/span>  22<\/span>\r\n  3<\/span> |<\/span> jo<\/span>   |<\/span> nagoya<\/span>  |<\/span>  32<\/span>\r\n  4<\/span> |<\/span> jjno<\/span> |<\/span> yagona<\/span>  |<\/span>  41<\/span>\r\n\r\n\r\n\r\n@<\/span>\u5e74\u4e0a\u306e\u4eba\u304b\u3089\u6574\u5217\u3059\u308b<\/span>\r\npostgres<\/span>=#<\/span> select<\/span> *<\/span> from<\/span> userlist<\/span> \r\n               order<\/span> by<\/span> age<\/span> desc<\/span>\r\n;<\/span>\r\n\r\n id<\/span> |<\/span> name<\/span> |<\/span> address<\/span> |<\/span> age<\/span>\r\n----+------+---------+-----<\/span>\r\n  4<\/span> |<\/span> jjno<\/span> |<\/span> yagona<\/span>  |<\/span>  41<\/span>\r\n  3<\/span> |<\/span> jo<\/span>   |<\/span> nagoya<\/span>  |<\/span>  32<\/span>\r\n  2<\/span> |<\/span> nao<\/span>  |<\/span> kyoto<\/span>   |<\/span>  22<\/span>\r\n  1<\/span> |<\/span> sato<\/span> |<\/span> tokyo<\/span>   |<\/span>  18<\/span>\r\n  5<\/span> |<\/span> ryo<\/span>  |<\/span> newyork<\/span> |<\/span>  15<\/span>\r\n<\/code><\/pre>\n
\r\n@<\/span>\\<\/span>d<\/span> \u30c6\u30fc\u30d6\u30eb\u69cb\u9020\u306e\u8868\u793a<\/span>\r\npostgres<\/span>=#<\/span> \\<\/span>d<\/span> userlist<\/span>;<\/span>\r\n           Table<\/span> \"public.userlist\"<\/span>\r\n Column<\/span>  |<\/span>         Type<\/span>          |<\/span> Modifiers<\/span>\r\n---------+-----------------------+-----------<\/span>\r\n id<\/span>      |<\/span> integer<\/span>               |<\/span>\r\n name<\/span>    |<\/span> character<\/span> varying<\/span>(<\/span>20<\/span>)<\/span> |<\/span>\r\n address<\/span> |<\/span> character<\/span> varying<\/span>(<\/span>30<\/span>)<\/span> |<\/span>\r\n age<\/span>     |<\/span> integer<\/span>               |<\/span>\r\n<\/code><\/pre>\n
update<\/span> -<\/span> \u30c7\u30fc\u30bf\u306e\u66f4\u65b0<\/span>\r\npostgres<\/span>=#<\/span> update<\/span> userlist<\/span>\r\n        set<\/span> address<\/span> =<\/span> 'fukuoka'<\/span> \r\n            where<\/span> name<\/span> =<\/span> 'toshi'<\/span> \r\n;<\/span>\r\nUPDATE<\/span> 2<\/span>\r\n\r\n<\/code><\/pre>\n
\r\npostgres<\/span>=#<\/span> select<\/span> *<\/span> from<\/span> userlist<\/span> ;<\/span>\r\n\r\n id<\/span> |<\/span> name<\/span>  |<\/span> address<\/span> |<\/span> age<\/span>\r\n----+-------+---------+-----<\/span>\r\n  1<\/span> |<\/span> sato<\/span>  |<\/span> tokyo<\/span>   |<\/span>  23<\/span>\r\n  2<\/span> |<\/span> ken<\/span>   |<\/span> nagoya<\/span>  |<\/span>  29<\/span>\r\n  2<\/span> |<\/span> toshi<\/span> |<\/span> fukuoka<\/span> |<\/span>  18<\/span>\r\n  2<\/span> |<\/span> toshi<\/span> |<\/span> fukuoka<\/span> |<\/span>  18<\/span>\r\n<\/code><\/pre>\n
@<\/span>delete<\/span> \u30c7\u30fc\u30bf\u306e\u524a\u9664<\/span>\r\npostgres<\/span>=#<\/span> delete<\/span> from<\/span> userlist<\/span> \r\nwhere<\/span> \r\n    name<\/span> =<\/span> 'toshi'<\/span> \r\n;<\/span>\r\nDELETE<\/span> 2<\/span>\r\n\r\n<\/code><\/pre>\n
\r\npostgres<\/span>=#<\/span> select<\/span> *<\/span> from<\/span> userlist<\/span> ;<\/span>\r\n\r\n id<\/span> |<\/span> name<\/span> |<\/span> address<\/span> |<\/span> age<\/span>\r\n----+------+---------+-----<\/span>\r\n  1<\/span> |<\/span> sato<\/span> |<\/span> tokyo<\/span>   |<\/span>  23<\/span>\r\n  2<\/span> |<\/span> ken<\/span>  |<\/span> nagoya<\/span>  |<\/span>  29<\/span>\r\n(<\/span>2<\/span> rows<\/span>)<\/span>\r\n<\/code><\/pre>\n
\r\npostgres<\/span>=#<\/span> insert<\/span> into<\/span> userlist<\/span> values<\/span> (<\/span>3<\/span>,<\/span> 'lisa'<\/span>,<\/span> 'paris'<\/span>)<\/span>\r\n;<\/span>\r\nERROR<\/span>:<\/span>  null<\/span> value<\/span> in<\/span> column<\/span> \"age\"<\/span> violates<\/span> not<\/span>-<\/span>null<\/span> constraint<\/span>\r\nDETAIL<\/span>:<\/span>  Failing<\/span> row<\/span> contains<\/span> (<\/span>3<\/span>,<\/span> lisa<\/span>,<\/span> paris<\/span>,<\/span> null<\/span>).<\/span>\r\n\r\n\r\npostgres<\/span>=#<\/span> insert<\/span> into<\/span> userlist<\/span> (<\/span>id<\/span>,<\/span> name<\/span>,<\/span> address<\/span>)<\/span> values<\/span> (<\/span>3<\/span>,<\/span> 'lisa'<\/span>,<\/span> 'paris'<\/span>)<\/span>\r\n;<\/span>\r\nERROR<\/span>:<\/span>  null<\/span> value<\/span> in<\/span> column<\/span> \"age\"<\/span> violates<\/span> not<\/span>-<\/span>null<\/span> constraint<\/span>\r\nDETAIL<\/span>:<\/span>  Failing<\/span> row<\/span> contains<\/span> (<\/span>3<\/span>,<\/span> lisa<\/span>,<\/span> paris<\/span>,<\/span> null<\/span>).<\/span>\r\n<\/code><\/pre>\n
#<\/span>\\<\/span>i<\/span> -<\/span> file<\/span>\u3092\u8aad\u307f\u8fbc\u307f<\/span>\r\n<\/code><\/pre>\n
SQL<\/span>\r\n\\<\/span>COPY<\/span> (<\/span> SQL<\/span> )<\/span>  TO<\/span> ' directory '<\/span> WITH<\/span> CSV<\/span> DELIMITER<\/span> ','<\/span> ;<\/span>\r\n\r\n\u4f8b\u6587<\/span>\r\n\\<\/span>COPY<\/span> (<\/span> select<\/span> address<\/span>,<\/span> max<\/span>(<\/span>age<\/span>),<\/span> min<\/span>(<\/span>age<\/span>),<\/span> avg<\/span>(<\/span>age<\/span>),<\/span> sum<\/span>(<\/span>age<\/span>),<\/span> count<\/span>(<\/span>*<\/span>)<\/span> from<\/span> userlist<\/span> group<\/span> by<\/span> address<\/span> )<\/span>  TO<\/span> '\/home\/sato\/data\/result1.csv'<\/span> WITH<\/span> CSV<\/span> DELIMITER<\/span> ','<\/span> ;<\/span>\r\n\r\n\r\n\\<\/span>COPY<\/span> (<\/span> select<\/span> address<\/span>,<\/span> max<\/span>(<\/span>age<\/span>),<\/span> min<\/span>(<\/span>age<\/span>),<\/span> avg<\/span>(<\/span>age<\/span>),<\/span> sum<\/span>(<\/span>age<\/span>),<\/span> count<\/span>(<\/span>*<\/span>)<\/span> from<\/span> userlist<\/span> group<\/span> by<\/span> address<\/span> )<\/span>  TO<\/span> '\/home\/sato\/data\/result1.csv'<\/span> WITH<\/span> CSV<\/span> DELIMITER<\/span> ','<\/span> HEADER<\/span> ;<\/span>\r\n<\/code><\/pre>\n
@<\/span>vi<\/span>\u30a8\u30c7\u30a3\u30bf\u3067\u3001\u307e\u3068\u3081\u3066\u3067\u304d\u308b<\/span>\r\n\r\nbegin<\/span> transaction<\/span> ;<\/span>\r\n\r\ndrop<\/span> table<\/span> userlist<\/span> ;<\/span>\r\n\r\ncreate<\/span> table<\/span> userlist<\/span>(<\/span>\r\n    id<\/span> int<\/span>,<\/span>\r\n       name<\/span> varchar<\/span>(<\/span>20<\/span>),<\/span>\r\n          address<\/span> varchar<\/span>(<\/span>30<\/span>),<\/span>\r\n               age<\/span> int<\/span> not<\/span> null<\/span>\r\n    )<\/span>\r\n;<\/span>\r\n\r\ninsert<\/span> into<\/span> userlist<\/span> values<\/span>(<\/span>1<\/span>,<\/span>'sato'<\/span>,<\/span>'tokyo'<\/span>,<\/span>18<\/span>);<\/span>\r\ninsert<\/span> into<\/span> userlist<\/span> values<\/span>(<\/span>2<\/span>,<\/span>'nao'<\/span>,<\/span>'kyoto'<\/span>,<\/span>22<\/span>);<\/span>\r\ninsert<\/span> into<\/span> userlist<\/span> values<\/span>(<\/span>3<\/span>,<\/span>'john'<\/span>,<\/span>'newyork'<\/span>,<\/span>34<\/span>);<\/span>\r\ninsert<\/span> into<\/span> userlist<\/span> values<\/span>(<\/span>4<\/span>,<\/span>'lisa'<\/span>,<\/span>'paris'<\/span>,<\/span>24<\/span>);<\/span>\r\ninsert<\/span> into<\/span> userlist<\/span> values<\/span>(<\/span>5<\/span>,<\/span>'kaoru'<\/span>,<\/span>'nagoya'<\/span>,<\/span>15<\/span>);<\/span>\r\ninsert<\/span> into<\/span> userlist<\/span> values<\/span>(<\/span>6<\/span>,<\/span>'ryo'<\/span>,<\/span>'fuhuoka'<\/span>,<\/span>40<\/span>);<\/span>\r\ninsert<\/span> into<\/span> userlist<\/span> values<\/span>(<\/span>7<\/span>,<\/span>'bob'<\/span>,<\/span>'tokyo'<\/span>,<\/span>23<\/span>);<\/span>\r\ninsert<\/span> into<\/span> userlist<\/span> values<\/span>(<\/span>8<\/span>,<\/span>'jack'<\/span>,<\/span>'kyoto'<\/span>,<\/span>35<\/span>);<\/span>\r\ninsert<\/span> into<\/span> userlist<\/span> values<\/span>(<\/span>9<\/span>,<\/span>'mary'<\/span>,<\/span>'newyork'<\/span>,<\/span>25<\/span>);<\/span>\r\ninsert<\/span> into<\/span> userlist<\/span> values<\/span>(<\/span>10<\/span>,<\/span>'linda'<\/span>,<\/span>'paris'<\/span>,<\/span>26<\/span>);<\/span>\r\ninsert<\/span> into<\/span> userlist<\/span> values<\/span>(<\/span>11<\/span>,<\/span>'yosuke'<\/span>,<\/span>'tokyo'<\/span>,<\/span>41<\/span>);<\/span>\r\ninsert<\/span> into<\/span> userlist<\/span> values<\/span>(<\/span>12<\/span>,<\/span>'takashi'<\/span>,<\/span>'fuhuoka'<\/span>,<\/span>19<\/span>);<\/span>\r\ninsert<\/span> into<\/span> userlist<\/span> values<\/span>(<\/span>13<\/span>,<\/span>'saori'<\/span>,<\/span>'kyoto'<\/span>,<\/span>21<\/span>);<\/span>\r\ninsert<\/span> into<\/span> userlist<\/span> values<\/span>(<\/span>14<\/span>,<\/span>'yuki'<\/span>,<\/span>'paris'<\/span>,<\/span>20<\/span>);<\/span>\r\ninsert<\/span> into<\/span> userlist<\/span> values<\/span>(<\/span>15<\/span>,<\/span>'tomo'<\/span>,<\/span>'newyork'<\/span>,<\/span>31<\/span>);<\/span>\r\ninsert<\/span> into<\/span> userlist<\/span> values<\/span>(<\/span>16<\/span>,<\/span>'take'<\/span>,<\/span>'tokyo'<\/span>,<\/span>36<\/span>);<\/span>\r\ninsert<\/span> into<\/span> userlist<\/span> values<\/span>(<\/span>17<\/span>,<\/span>'yusuke'<\/span>,<\/span>'nagoya'<\/span>,<\/span>22<\/span>);<\/span>\r\ninsert<\/span> into<\/span> userlist<\/span> values<\/span>(<\/span>18<\/span>,<\/span>'nori'<\/span>,<\/span>'tokyo'<\/span>,<\/span>19<\/span>);<\/span>\r\ninsert<\/span> into<\/span> userlist<\/span> values<\/span>(<\/span>19<\/span>,<\/span>'mari'<\/span>,<\/span>'newyork'<\/span>,<\/span>20<\/span>);<\/span>\r\ninsert<\/span> into<\/span> userlist<\/span> values<\/span>(<\/span>20<\/span>,<\/span>'sachi'<\/span>,<\/span>'nagoya'<\/span>,<\/span>36<\/span>);<\/span>\r\ninsert<\/span> into<\/span> userlist<\/span> values<\/span>(<\/span>21<\/span>,<\/span>'jun'<\/span>,<\/span>'tokyo'<\/span>,<\/span>34<\/span>);<\/span>\r\ninsert<\/span> into<\/span> userlist<\/span> values<\/span>(<\/span>22<\/span>,<\/span>'yasuko'<\/span>,<\/span>'nagoya'<\/span>,<\/span>28<\/span>);<\/span>\r\ninsert<\/span> into<\/span> userlist<\/span> values<\/span>(<\/span>23<\/span>,<\/span>'reo'<\/span>,<\/span>'nagoya'<\/span>,<\/span>33<\/span>);<\/span>\r\ninsert<\/span> into<\/span> userlist<\/span> values<\/span>(<\/span>24<\/span>,<\/span>'hana'<\/span>,<\/span>'tokyo'<\/span>,<\/span>22<\/span>);<\/span>\r\ninsert<\/span> into<\/span> userlist<\/span> values<\/span>(<\/span>25<\/span>,<\/span>'asa'<\/span>,<\/span>'newyork'<\/span>,<\/span>25<\/span>);<\/span>\r\ninsert<\/span> into<\/span> userlist<\/span> values<\/span>(<\/span>26<\/span>,<\/span>'ryo'<\/span>,<\/span>'paris'<\/span>,<\/span>36<\/span>);<\/span>\r\ninsert<\/span> into<\/span> userlist<\/span> values<\/span>(<\/span>27<\/span>,<\/span>'kyoko'<\/span>,<\/span>'tokyo'<\/span>,<\/span>34<\/span>);<\/span>\r\ninsert<\/span> into<\/span> userlist<\/span> values<\/span>(<\/span>28<\/span>,<\/span>'chan'<\/span>,<\/span>'paris'<\/span>,<\/span>28<\/span>);<\/span>\r\ninsert<\/span> into<\/span> userlist<\/span> values<\/span>(<\/span>29<\/span>,<\/span>'misa'<\/span>,<\/span>'newyork'<\/span>,<\/span>18<\/span>);<\/span>\r\ninsert<\/span> into<\/span> userlist<\/span> values<\/span>(<\/span>30<\/span>,<\/span>'toshi'<\/span>,<\/span>'paris'<\/span>,<\/span>22<\/span>);<\/span>\r\ninsert<\/span> into<\/span> userlist<\/span> values<\/span>(<\/span>31<\/span>,<\/span>'reiko'<\/span>,<\/span>'tokyo'<\/span>,<\/span>32<\/span>);<\/span>\r\ninsert<\/span> into<\/span> userlist<\/span> values<\/span>(<\/span>32<\/span>,<\/span>'kiki'<\/span>,<\/span>'fuhuoka'<\/span>,<\/span>35<\/span>);<\/span>\r\ninsert<\/span> into<\/span> userlist<\/span> values<\/span>(<\/span>33<\/span>,<\/span>'lulu'<\/span>,<\/span>'tokyo'<\/span>,<\/span>26<\/span>);<\/span>\r\ninsert<\/span> into<\/span> userlist<\/span> values<\/span>(<\/span>34<\/span>,<\/span>'panda'<\/span>,<\/span>'tokyo'<\/span>,<\/span>35<\/span>);<\/span>\r\ninsert<\/span> into<\/span> userlist<\/span> values<\/span>(<\/span>35<\/span>,<\/span>'mashi'<\/span>,<\/span>'newyork'<\/span>,<\/span>27<\/span>);<\/span>\r\ninsert<\/span> into<\/span> userlist<\/span> values<\/span>(<\/span>36<\/span>,<\/span>'zuke'<\/span>,<\/span>'tokyo'<\/span>,<\/span>33<\/span>);<\/span>\r\ninsert<\/span> into<\/span> userlist<\/span> values<\/span>(<\/span>37<\/span>,<\/span>'dore'<\/span>,<\/span>'paris'<\/span>,<\/span>28<\/span>);<\/span>\r\ninsert<\/span> into<\/span> userlist<\/span> values<\/span>(<\/span>38<\/span>,<\/span>'mishima'<\/span>,<\/span>'tokyo'<\/span>,<\/span>25<\/span>);<\/span>\r\ninsert<\/span> into<\/span> userlist<\/span> values<\/span>(<\/span>39<\/span>,<\/span>'lyly'<\/span>,<\/span>'fuhuoka'<\/span>,<\/span>19<\/span>);<\/span>\r\ninsert<\/span> into<\/span> userlist<\/span> values<\/span>(<\/span>40<\/span>,<\/span>'osu'<\/span>,<\/span>'newyork'<\/span>,<\/span>22<\/span>);<\/span>\r\ninsert<\/span> into<\/span> userlist<\/span> values<\/span>(<\/span>41<\/span>,<\/span>'sati'<\/span>,<\/span>'tokyo'<\/span>,<\/span>25<\/span>);<\/span>\r\ninsert<\/span> into<\/span> userlist<\/span> values<\/span>(<\/span>42<\/span>,<\/span>'kiriko'<\/span>,<\/span>'fuhuoka'<\/span>,<\/span>27<\/span>);<\/span>\r\n\r\ncommit<\/span> \r\n;<\/span>\r\n<\/code><\/pre>\n
postgres<\/span>=#<\/span> select<\/span> *<\/span> from<\/span> userlist<\/span> \r\nwhere<\/span> \r\n    address<\/span> in<\/span> (<\/span>'tokyo'<\/span>,<\/span> 'kyoto'<\/span>)<\/span> \r\n;<\/span>\r\n\r\n id<\/span> |<\/span>  name<\/span>   |<\/span> address<\/span> |<\/span> age<\/span>\r\n----+---------+---------+-----<\/span>\r\n  1<\/span> |<\/span> sato<\/span>    |<\/span> tokyo<\/span>   |<\/span>  18<\/span>\r\n  2<\/span> |<\/span> nao<\/span>     |<\/span> kyoto<\/span>   |<\/span>  22<\/span>\r\n  7<\/span> |<\/span> bob<\/span>     |<\/span> tokyo<\/span>   |<\/span>  23<\/span>\r\n  8<\/span> |<\/span> jack<\/span>    |<\/span> kyoto<\/span>   |<\/span>  35<\/span>\r\n 11<\/span> |<\/span> yosuke<\/span>  |<\/span> tokyo<\/span>   |<\/span>  41<\/span>\r\n 13<\/span> |<\/span> saori<\/span>   |<\/span> kyoto<\/span>   |<\/span>  21<\/span>\r\n 16<\/span> |<\/span> take<\/span>    |<\/span> tokyo<\/span>   |<\/span>  36<\/span>\r\n 18<\/span> |<\/span> nori<\/span>    |<\/span> tokyo<\/span>   |<\/span>  19<\/span>\r\n 21<\/span> |<\/span> jun<\/span>     |<\/span> tokyo<\/span>   |<\/span>  34<\/span>\r\n 24<\/span> |<\/span> hana<\/span>    |<\/span> tokyo<\/span>   |<\/span>  22<\/span>\r\n 27<\/span> |<\/span> kyoko<\/span>   |<\/span> tokyo<\/span>   |<\/span>  34<\/span>\r\n 31<\/span> |<\/span> reiko<\/span>   |<\/span> tokyo<\/span>   |<\/span>  32<\/span>\r\n 33<\/span> |<\/span> lulu<\/span>    |<\/span> tokyo<\/span>   |<\/span>  26<\/span>\r\n 34<\/span> |<\/span> panda<\/span>   |<\/span> tokyo<\/span>   |<\/span>  35<\/span>\r\n 36<\/span> |<\/span> zuke<\/span>    |<\/span> tokyo<\/span>   |<\/span>  33<\/span>\r\n 38<\/span> |<\/span> mishima<\/span> |<\/span> tokyo<\/span>   |<\/span>  25<\/span>\r\n 41<\/span> |<\/span> sati<\/span>    |<\/span> tokyo<\/span>   |<\/span>  25<\/span>\r\n(<\/span>17<\/span> rows<\/span>)<\/span>\r\n<\/code><\/pre>\n
postgres<\/span>=#<\/span> update<\/span> userlist<\/span> \r\n             set<\/span> address<\/span> =<\/span> 'london'<\/span> \r\nwhere<\/span> \r\n    address<\/span> in<\/span>(<\/span>'tokyo'<\/span>,<\/span> 'kyoto'<\/span>,<\/span>'nagoya'<\/span>)<\/span> \r\n  and<\/span> \r\n   age<\/span> <=<\/span> 19<\/span> \r\n;<\/span>\r\n\r\nUPDATE<\/span> 3<\/span>\r\n<\/code><\/pre>\n
\r\npostgres<\/span>=#<\/span> select<\/span> *<\/span> from<\/span> userlist<\/span> \r\n    where<\/span>\r\n        address<\/span> =<\/span> 'london'<\/span>\r\n;<\/span>\r\n\r\n id<\/span> |<\/span> name<\/span>  |<\/span> address<\/span> |<\/span> age<\/span>\r\n----+-------+---------+-----<\/span>\r\n  1<\/span> |<\/span> sato<\/span>  |<\/span> london<\/span>  |<\/span>  18<\/span>\r\n  5<\/span> |<\/span> kaoru<\/span> |<\/span> london<\/span>  |<\/span>  15<\/span>\r\n 18<\/span> |<\/span> nori<\/span>  |<\/span> london<\/span>  |<\/span>  19<\/span>\r\n(<\/span>3<\/span> rows<\/span>)<\/span>\r\n<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"
@name, age, age+10\u8868\u793a\u300120\u4ee3\u4eba\u3060\u3051\u63a2\u3059\u306e\u6761\u4ef6 postgres=# select name […]<\/p>\n","protected":false},"author":9,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[227],"class_list":["post-27378","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-227"],"yoast_head":"\nCentOS \u4e0a\u7684 PostgreSQL - Blog - Silicon Cloud<\/title>\n<meta name=\"description\" content=\"\u5173\u4e8eCentOS \u4e0a\u7684 PostgreSQL\u7684\u6280\u672f\u6587\u7ae0\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.silicloud.com\/zh\/blog\/centos-\u4e0a\u7684-postgresql-2\/\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"CentOS \u4e0a\u7684 PostgreSQL\" \/>\n<meta property=\"og:description\" content=\"\u5173\u4e8eCentOS \u4e0a\u7684 PostgreSQL\u7684\u6280\u672f\u6587\u7ae0\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/zh\/blog\/centos-\u4e0a\u7684-postgresql-2\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:published_time\" content=\"2023-10-08T21:11:48+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-08-11T18:22:11+00:00\" \/>\n<meta name=\"author\" content=\"\u6e05, \u626c\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u4f5c\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"\u6e05, \u626c\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/centos-%e4%b8%8a%e7%9a%84-postgresql-2\/\",\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/centos-%e4%b8%8a%e7%9a%84-postgresql-2\/\",\"name\":\"CentOS \u4e0a\u7684 PostgreSQL - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#website\"},\"datePublished\":\"2023-10-08T21:11:48+00:00\",\"dateModified\":\"2025-08-11T18:22:11+00:00\",\"author\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/cb5556d2501da73d864cac945e8d9461\"},\"description\":\"\u5173\u4e8eCentOS \u4e0a\u7684 PostgreSQL\u7684\u6280\u672f\u6587\u7ae0\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/centos-%e4%b8%8a%e7%9a%84-postgresql-2\/#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/zh\/blog\/centos-%e4%b8%8a%e7%9a%84-postgresql-2\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/centos-%e4%b8%8a%e7%9a%84-postgresql-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9875\",\"item\":\"https:\/\/www.silicloud.com\/zh\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"CentOS \u4e0a\u7684 PostgreSQL\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#website\",\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/\",\"name\":\"Blog - Silicon Cloud\",\"description\":\"\",\"inLanguage\":\"zh-Hans\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/cb5556d2501da73d864cac945e8d9461\",\"name\":\"\u6e05, \u626c\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/32a4239de8ff29adace466261d309424a1e5fe9f7e3036bf89fe03f2e3dbe717?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/32a4239de8ff29adace466261d309424a1e5fe9f7e3036bf89fe03f2e3dbe717?s=96&d=mm&r=g\",\"caption\":\"\u6e05, \u626c\"},\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/author\/qingyang\/\"},{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/centos-%e4%b8%8a%e7%9a%84-postgresql-2\/#local-main-organization-logo\",\"url\":\"\",\"contentUrl\":\"\",\"caption\":\"Blog - Silicon Cloud\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"CentOS \u4e0a\u7684 PostgreSQL - Blog - Silicon Cloud","description":"\u5173\u4e8eCentOS \u4e0a\u7684 PostgreSQL\u7684\u6280\u672f\u6587\u7ae0","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.silicloud.com\/zh\/blog\/centos-\u4e0a\u7684-postgresql-2\/","og_locale":"zh_CN","og_type":"article","og_title":"CentOS \u4e0a\u7684 PostgreSQL","og_description":"\u5173\u4e8eCentOS \u4e0a\u7684 PostgreSQL\u7684\u6280\u672f\u6587\u7ae0","og_url":"https:\/\/www.silicloud.com\/zh\/blog\/centos-\u4e0a\u7684-postgresql-2\/","og_site_name":"Blog - Silicon Cloud","article_published_time":"2023-10-08T21:11:48+00:00","article_modified_time":"2025-08-11T18:22:11+00:00","author":"\u6e05, \u626c","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":"\u6e05, \u626c"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/zh\/blog\/centos-%e4%b8%8a%e7%9a%84-postgresql-2\/","url":"https:\/\/www.silicloud.com\/zh\/blog\/centos-%e4%b8%8a%e7%9a%84-postgresql-2\/","name":"CentOS \u4e0a\u7684 PostgreSQL - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#website"},"datePublished":"2023-10-08T21:11:48+00:00","dateModified":"2025-08-11T18:22:11+00:00","author":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/cb5556d2501da73d864cac945e8d9461"},"description":"\u5173\u4e8eCentOS \u4e0a\u7684 PostgreSQL\u7684\u6280\u672f\u6587\u7ae0","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/centos-%e4%b8%8a%e7%9a%84-postgresql-2\/#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/zh\/blog\/centos-%e4%b8%8a%e7%9a%84-postgresql-2\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/zh\/blog\/centos-%e4%b8%8a%e7%9a%84-postgresql-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9875","item":"https:\/\/www.silicloud.com\/zh\/blog\/"},{"@type":"ListItem","position":2,"name":"CentOS \u4e0a\u7684 PostgreSQL"}]},{"@type":"WebSite","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#website","url":"https:\/\/www.silicloud.com\/zh\/blog\/","name":"Blog - Silicon Cloud","description":"","inLanguage":"zh-Hans"},{"@type":"Person","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/cb5556d2501da73d864cac945e8d9461","name":"\u6e05, \u626c","image":{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/32a4239de8ff29adace466261d309424a1e5fe9f7e3036bf89fe03f2e3dbe717?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/32a4239de8ff29adace466261d309424a1e5fe9f7e3036bf89fe03f2e3dbe717?s=96&d=mm&r=g","caption":"\u6e05, \u626c"},"url":"https:\/\/www.silicloud.com\/zh\/blog\/author\/qingyang\/"},{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.silicloud.com\/zh\/blog\/centos-%e4%b8%8a%e7%9a%84-postgresql-2\/#local-main-organization-logo","url":"","contentUrl":"","caption":"Blog - Silicon Cloud"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/27378","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/users\/9"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/comments?post=27378"}],"version-history":[{"count":2,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/27378\/revisions"}],"predecessor-version":[{"id":89497,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/27378\/revisions\/89497"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/media?parent=27378"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/categories?post=27378"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/tags?post=27378"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}