shrill
发表于 2025-3-23 10:38:51
http://reply.papertrans.cn/19/1824/182303/182303_11.png
Inveterate
发表于 2025-3-23 14:52:33
Getting Started with PostgreSQL,y is probably to use some form of precompiled binary package. We provided step-by-step instructions for compiling, installing, and confirming a working installation on Linux systems from packages, UNIX-compatible systems from source code, and Windows systems using the Microsoft Windows installer..Fi
Juvenile
发表于 2025-3-23 18:38:21
Accessing Your Data, columns and rows, how to order the output, and how to suppress duplicate information. We also learned a bit about the date type, and how to configure PostgreSQL’s behavior in interpreting and displaying dates, as well as how to use dates in condition statements..We then moved on to the heart of SQL
Pedagogy
发表于 2025-3-23 22:22:58
http://reply.papertrans.cn/19/1824/182303/182303_14.png
promote
发表于 2025-3-24 04:22:02
Data Interfacing,ta with the UPDATE command, and remove data with the DELETE command..We learned about the two forms of the INSERT command, with data explicitly included in the INSERT statement or INSERT from data SELECTed from another table. We saw how it is safer to use the longer form of the INSERT statement, whe
按时间顺序
发表于 2025-3-24 10:20:01
http://reply.papertrans.cn/19/1824/182303/182303_16.png
阴郁
发表于 2025-3-24 14:11:37
PostgreSQL Administration, we might want to adjust. Then we looked at database initialization and server control..Next, we discussed how we can manage the internals of a PostgreSQL server: creating databases, adding users, and managing how PostgreSQL places the physical files underlying the internal databases..Then we looked
Entreaty
发表于 2025-3-24 17:05:38
Database Design,the conceptual design into a physical database design or schema. Along the way, we covered selecting candidate keys, primary keys, and foreign keys. We also looked at choosing data types for our columns, and talked about the importance of consistency in database design..We briefly mentioned normal f
GIST
发表于 2025-3-24 20:09:59
Accessing PostgreSQL from C Using libpq,eSQL, allowing us to connect to a database on a local machine or on a server across the network. We have used sample programs to make and close connections, and execute SQL statements to query, insert, or update rows in our database tables..We have considered problems of handling large volumes of da
尖
发表于 2025-3-25 00:04:21
Accessing PostgreSQL from PHP,tabase connections, query building and execution, result set manipulation, and error handling. We also introduced the PEAR database abstraction interface..In the next chapter, we’ll explore how to access a PostgreSQL database from Perl.