- Practical PostgreSQL
- A Note Regarding Supplemental Files
- Preface
- I. Introduction & Installation
- 1. What Is PostgreSQL?
- 2. Installing PostgreSQL
- Preparing for Installation
- 10 Steps to Installing PostgreSQL
- Step 1: Creating the “postgres” User
- Step 2: Installing the PostgreSQL Source Package
- Step 3: Configuring the Source Tree
- Step 4: Compiling the Source
- Step 5: Regression Testing
- Step 6: Installing Compiled Programs and Libraries
- Step 7: Setting Environment Variables
- Step 8: Initializing and Starting PostgreSQL
- Step 9: Configuring the PostgreSQL SysV Script
- Step 10: Creating a Database
- II. Using PostgreSQL
- 3. Understanding SQL
- Introduction to SQL
- Introduction to Relational Databases
- SQL Statements
- Data Types
- Tables in PostgreSQL
- 4. Using SQL with PostgreSQL
- Introduction to psql
- Using Tables
- Adding Data with INSERT and COPY
- Retrieving Rows with SELECT
- A Simple SELECT
- Specifying Target Columns
- Expressions, Constants, and Aliases
- Selecting Sources with the FROM Clause
- Aliasing FROM Sources
- Removing Duplicate Rows with DISTINCT
- Qualifying with the WHERE Clause
- Joining Data Sets with JOIN
- Grouping Rows with GROUP BY
- Sorting Rows with ORDER BY
- Setting Row Range with LIMIT and OFFSET
- Comparing Sets with UNION, INTERSECT and EXCEPT
- Using Case Expressions
- Creating Tables from Other Tables
- Modifying Rows with UPDATE
- Removing Rows with DELETE
- Using Sub-Queries
- Using Views
- Further SQL Application
- 5. Operators and Functions
- 6. PostgreSQL Clients
- 7. Advanced Features
- Indices
- Advanced Table Techniques
- Arrays
- Automating Common Routines
- Transactions and Cursors
- Extending PostgreSQL
- Creating New Functions
- Creating New Operators
- Creating an operator
- Overloading an operator
- Dropping an operator
- III. Administrating PostgreSQL
- 8. Authentication and Encryption
- 9. Database Management
- 10. User and Group Management
- IV. PostgreSQL Programming
- 11. PL/pgSQL
- 12. JDBC
- 13. LXP
- V. Command Reference
- 14. PostgreSQL Command Reference
- Abort
- Alter Group
- Alter Table
- Alter User
- Begin
- Close
- Cluster
- Comment
- Commit
- Copy
- Create Aggregate
- Create Database
- Create Function
- Create Group
- Create Index
- Create Language
- Create Operator
- Create Rule
- Create Sequence
- Create Table
- Create Table As
- Create Trigger
- Create Type
- Create User
- Create View
- Current_Date
- Current_Time
- Current_Timestamp
- Current_User
- Declare
- Delete
- Drop Aggregate
- Drop Database
- Drop Function
- Drop Group
- Drop Index
- Drop Language
- Drop Operator
- Drop Rule
- Drop Sequence
- Drop Table
- Drop Trigger
- Drop Type
- Drop User
- DROP VIEW
- End
- Explain
- FETCH
- Grant
- Insert
- Listen
- Load
- Lock
- Move
- Notify
- Reindex
- Reset
- Revoke
- Rollback
- Select
- Select Into
- Set
- Set Constraints
- Set Transaction
- Show
- Truncate
- Unlisten
- Update
- Vacuum
- A. Multibyte Encoding Types
- B. Backend Options for postgres
- C. Binary COPY Format
- D. Internal psql Variables
- 14. PostgreSQL Command Reference
- E. About the Authors
- Index
- Colophon
- Copyright
- 3. Understanding SQL
Creates a view on a table.
CREATE VIEW view AS query
viewThe name of the view to create.
queryThe SQL query to provide the columns and rows of the view.
CREATEThe message returned when a view is successfully created.
ERROR: Relation 'view' already existsThe error returned if a view with the name you supplied (
view) already exists.NOTICE create: attribute“column”has an unknown typeThe notice returned if the data type for
columnin thequerydefinition is of an ambiguous type.
Use CREATE VIEW to define a new table view within the current
database.
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.