- Learning PostgreSQL 11
- Salahaldin Juba Andrey Volkov
- 110字
- 2021-07-02 13:11:39
The RENAME operation
The RENAME operation is used to alter the attribute name of the resultant relation or to give a specific name to the resultant relation. The RENAME operation is used to perform the following:
- Remove confusion if two or more relations have attributes with the same name
- Provide user-friendly names for attributes, especially when interfacing with reporting engines
- Provide a convenient way to change the relation definition and still be backward compatible
The AS keyword in SQL is the equivalent of the RENAME operator in relational algebra. The following SQL example creates a relation with one tuple and one attribute, which is renamed PI:
SELECT 3.14::real AS PI;
推薦閱讀
- Getting Started with ResearchKit
- Practical Data Science Cookbook(Second Edition)
- Hands-On Data Structures and Algorithms with JavaScript
- 軟件測(cè)試工程師面試秘籍
- Python Deep Learning
- 趣學(xué)Python算法100例
- Hands-On JavaScript High Performance
- Java 11 Cookbook
- iOS編程基礎(chǔ):Swift、Xcode和Cocoa入門(mén)指南
- Learning YARN
- Programming Microsoft Dynamics? NAV 2015
- Oracle數(shù)據(jù)庫(kù)編程經(jīng)典300例
- Android Game Programming by Example
- Python 3 Object:oriented Programming(Second Edition)
- Application Development with Parse using iOS SDK