PostgreSQL

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


postmaster, see administration, server


PQclear(), 191


PQconnectdb(), 191


PQexec(), 191


PQfinish(), 191


PQgetvalue(), 191


PQntuples(), 191


primary key, see constraint, primary key index creation, 158 programming, 187-201, 219-222 compiling, 191-195 scripting, 196-198, 200-201 server-side, 203-216, 258


variables, 195-196 ps, 229


psql, 5-9, 177-184, 189, 223, 238, 258, 402422


buffer commands, 177 command args, 184 copy, 175


format commands, 177-180 general commands, 177 help, 9


internal queries, 247-248 large object, 183 listing, 180-183 prompt, 14-15, 30 variables, 180 Python, 188,199, 201, 242


quotes, 14, 17, 25


around identifiers, 60-62


raise exception, 216 rdbms, see relational database read committed, 125-127 referential integrity, 158-166 regular expression, see where, regular expression reject, 226


relation does not exist, 17


relational database, 1,11-13,17, 57, 62,107


reset, 43-46, 257, 423


restore, see administration, restore


revoke, 143, 424-426


round(), 113


rpad(), 113


rule, 149-151, 257, 296-299, 345 compared to trigger, 210-216 grant, 143 listing, 231


scripting, see programming, scripting sed, 171


select, 6,15-17, 427-436 and insert, 103


column label, 6, 26-30, 40, 49, 65 create table, 103-105 cursor, 137-138 distinct, 40 for update, 128 grant, 143 group by, 51, 65, 92 having, 51, 92 into, 103-105, 141, 175 limit, 137, 246, 257 order by, 19, 51, 87, 248 cluster, 133 descending, 19 index, 132, 136 limit, 137 union, 87


subquery, see subquery self join, see join, self


sequence, 81-86,250-251,257,300-302,346 listing, 183 sequential scan, 134 serial, 85, 250-251, 257 serializable, 125-128 server, see administration, server server-side programming, see programming, server-side


set, 43-46, 232, 246, 257, 437-443 setval(), 82


show, 43-46, 257, 443-444 spi, 220

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