PostgreSQL数据库入门(3)

    date   |                             repairs                             

-----------+-----------------------------------------------------------------

2008-08-08| oil change, air filter, spark plugs

2011-09-30|35000 service, oil change, rotate tires/balance wheels

2012-03-07| repl battery

2012-11-14|45000 maint, oil/filter

2014-04-09|55000 maint, oil/filter, spark plugs, air/dust filters

2014-04-21| replace 4 tires

2014-04-21| wheel alignment

2016-06-01|65000 mile service, oil change

2017-05-16| oil change, replce oil filt housing

2017-05-26| rotate tires

2017-06-05| air filter, cabin filter,spark plugs

2017-06-05| brake pads and rotors, flush brakes

2017-08-11| airbag recall

2018-07-06| oil/filter change, fuel filter, battery svc

2018-07-06| transmission fl, p steering fl, rear diff fl

2019-07-22| oil & filter change, brake fluid flush, front differential flush

2019-08-20| replace 4 tires

2019-10-09| replace passenger taillight bulb

2019-10-25| replace passenger taillight assembly

(19 rows)

要将此发送到文件，将输出更改为：

\o autorepairs.txt

然后再次运行 SELECT 命令。

最后，在终端中退出 PostgreSQL，输入：

quit

或者它的缩写版：

\q

虽然这只是 PostgreSQL 的简要介绍，但我希望它展示了将数据库用于这样的简单任务既不困难也不费时。

（编辑：ASP站长网）