PostgreSQL

Скачать в pdf «PostgreSQL»


select *


FROM films


WHERE kind = ‘Dramatic’ OR kind = ‘Drama’;


code |


title |


did


|


date prod


|


kind


|


len


blioi |


The Third Man |


101


|


1949-12-23


|


Dramatic


|


01:44


P_302 |


Becket |


l—»


О


OJ


|


1964-02-03


|


Dramatic


|


02:28


M_401 |


War and Peace |


1—» о


-C*


|


1967-02-12


|


Dramatic


|


05:57


T_601 |


Yojimbo |


106


|


1961-06-16


|


Dramatic


|


01:50


DA101 |


Das Boot |


110


|


1981-11-11


|


Dramatic


|


02:29

Compatibility


SQL92


SQL92 defines a different syntax for the positioned UPDATE statement: UPDATE table


SET column = expression [, …]


WHERE CURRENT OF cursor


where cursor identifies an open cursor.

D.85 VACUUM


Name


VACUUM — Clean and analyze a Postgres database VACUUM [ VERBOSE ] [ ANALYZE ] [ table ]


VACUUM [ VERBOSE ] ANALYZE [ table [ (column [,…] ) ] ]


Inputs


VERBOSE Prints a detailed vacuum activity report for each table.


ANALYZE Updates column statistics used by the optimizer to determine the most efficient way to execute a query.

Скачать в pdf «PostgreSQL»