PostgreSQL examples (example source code) Organized by topic

PostgreSQL

1. Aggregate Functions

2. Analytical Functions

3. Array

4. Constraints

5. Cursor

6. Data Type

7. Database

8. Date Timezone

9. Index

10. Inheritance

11. Insert Delete Update

12. Math Functions

13. Postgre SQL

14. Select Query

15. Sequence

16. Store Procedure Function

17. String Functions

18. Subquery

19. Table

20. Table Joins

21. Transaction

22. User Previliege

23. View

Java

Java Tutorial

Java Source Code / Java Documentation

Java Open Source

Jar File Download

Java Articles

Java Products

Java by API

C# / C Sharp

C# / CSharp Tutorial

ASP.Net

JavaScript DHTML

JavaScript Tutorial

JavaScript Reference

HTML / CSS

HTML CSS Reference

C / ANSI-C

C Tutorial

C++

C++ Tutorial

PHP

Python

SQL Server / T-SQL

SQL Server / T-SQL Tutorial

Oracle PL / SQL

Oracle PL/SQL Tutorial

SQL / MySQL

MySQL Tutorial

VB.Net

VB.Net Tutorial

Flash / Flex / ActionScript

VBA / Excel / Access / Word

Microsoft Office PowerPoint 2007 Tutorial

Microsoft Office Excel 2007 Tutorial

Microsoft Office Word 2007 Tutorial

PostgreSQL

Select Query Insert Delete Update Subquery

Select Query

AND( 2 ) AS( 1 ) BETWEEN( 2 ) Case( 2 ) Compare Row( 1 ) Comparison Operators( 3 )

Constant( 1 ) DISTINCT( 3 ) EXCEPT( 1 ) EXPLAIN Query( 2 ) Expressions( 1 ) Group By( 1 )

Having( 2 ) INTERSECT( 1 ) IS NULL( 1 ) Like( 2 ) LIMIT( 2 ) Mathematical Operators( 1 )

NOT( 1 ) NULL( 2 ) OFFSET( 1 ) Operator Precedence( 1 ) OR( 1 ) Order( 5 )

Query Column( 3 ) Query Expressions( 1 ) Quotation( 1 ) Row( 4 ) SELECT INTO( 1 ) String Compare( 1 )

UNION( 3 ) WHERE( 6 )

Insert Delete Update

DELETE ONLY( 1 ) Delete( 5 ) Insert Select( 3 ) Insert( 9 ) Select( 6 ) Update( 9 )

Subquery

Subquery Basics( 4 ) Subquery Case( 1 ) Subquery IN( 2 )

Table Table Joins View Database

Table

Add Column( 5 ) Add Comments( 1 ) Alter Column( 1 ) Column Type( 1 ) Composite Column( 3 ) Copy Table( 1 )

Create Table( 2 ) Drop Table( 2 ) File to Table( 2 ) Remove Column( 2 ) Rename Column( 3 ) Rename Table( 2 )

Table info( 1 ) Table Ownership( 1 ) Table Previlege( 1 ) Table to File( 2 ) Temporary Table( 1 ) TRUNCATE( 1 )

Table Joins

CROSS JOIN( 2 ) Full Join( 1 ) INNER JOIN( 5 ) Left Join( 3 ) LEFT OUTER JOIN( 1 ) Natural Join( 3 )

NATURAL( 1 ) Outter Join( 1 ) Right Join( 1 ) Table Join( 5 )

View

Create View( 3 ) User Permission( 1 ) View Privilege( 2 )

Database

Comment Database( 1 ) Create Database( 1 ) Drop Database( 1 ) USING( 1 )

Cursor Transaction

Cursor

Close Cursor( 1 ) Declare Cursor( 2 ) Fetch Backward( 1 ) FETCH FORWARD( 1 ) FETCH( 4 ) Move Cursor( 1 )

Transaction

Abort( 1 ) Begins Transaction( 1 ) COMMIT( 2 ) Rollback( 2 ) SAVEPOINT( 1 ) Transaction Isolation( 4 )

Store Procedure Function Postgre SQL

Store Procedure Function

Create Function( 6 ) Drop Function( 1 ) Function Call( 1 ) Function Parameter( 9 ) Function Return( 7 ) Input Alias( 1 )

Postgre SQL

Assign Variable( 2 ) Code Block( 3 ) Comments( 2 ) Create Language( 1 ) current config( 1 ) current_database( 1 )

current_schema( 3 ) Declare Variable( 2 ) Decode( 1 ) Delete Data( 1 ) Exception( 1 ) File Read( 1 )

For( 1 ) generate_series( 4 ) If( 1 ) Inet Address( 2 ) Inet Port( 2 ) Insert Data( 2 )

Insert Variable( 2 ) Local Variable( 1 ) Log Function( 1 ) LOOP( 1 ) pg_language( 1 ) plpgsql( 1 )

Postgre SQL Command( 15 ) RAISE DEBUG( 1 ) RAISE EXCEPTION( 1 ) RAISE NOTICE( 1 ) RECORD( 1 ) ROWTYPE( 3 )

Set Value( 3 ) set_config( 1 ) String Calculation( 2 ) String Concatenate( 4 ) Type( 5 ) Update Data( 1 )

VACUUM( 1 ) Variable Default( 1 ) Version( 1 ) While( 2 )

Data Type Date Timezone Array

Data Type

Bit Shift( 1 ) Bit( 1 ) Boolean( 9 ) Cast( 4 ) Float( 2 ) Integer( 1 )

Money Format( 1 ) Money( 1 ) numeric( 2 ) Point( 4 ) text( 2 ) varchar( 1 )

Date Timezone

current_date( 1 ) current_time( 1 ) Current_Timestamp( 1 ) Date Compare( 1 ) Date Format( 1 ) Date Interval format( 1 )

Date Time Format( 7 ) date( 1 ) DATESTYLE( 5 ) date_part( 1 ) date_trunc( 3 ) extract( 1 )

now( 3 ) timeofday( 1 ) timestamp( 1 ) to_timestamp( 1 )

Array

Any Array( 1 ) Array Column Insert( 5 ) Array Column Select( 12 ) Array Column Update( 6 ) Array Column( 4 ) Array Constructor( 1 )

Array Slice( 2 ) Array Upper( 1 ) array_append( 1 ) array_cat( 3 ) array_dims( 1 ) array_prepend( 1 )

Concatenate Array( 7 ) Nested Array( 1 )

Constraints Index Sequence Inheritance

Constraints

Add Constraints( 3 ) Add Primary Key( 1 ) Check( 2 ) Column Relations( 1 ) CONSTRAINT( 1 ) Constraints Basics( 4 )

Create Rule( 1 ) Default( 4 ) Drop Constraints( 2 ) FOREIGN KEY( 7 ) NOT NULL( 1 ) Primary Key( 7 )

Unique( 5 )

Index

Create Index( 4 ) Drop Index( 1 ) REINDEX( 1 )

Sequence

Create Sequence( 2 ) Currval( 1 ) Drop Sequence( 1 ) nextval( 1 ) Sequence Value( 5 ) setval( 1 )

Inheritance

Children Table( 1 ) INHERITS( 1 ) Insert Data Children( 1 ) Select Inheritance( 2 ) Update Inheritance Only( 1 ) Update Inheritance( 1 )

Aggregate Functions Analytical Functions String Functions Math Functions

Aggregate Functions

Aggregate Function( 1 ) AVG( 1 ) max( 3 ) Min( 1 ) SUM( 2 )

Analytical Functions

Count( 2 ) stddev( 2 ) Variance( 2 ) width_bucket( 1 )

String Functions

ascii( 2 ) btrim( 3 ) char_length( 2 ) chr( 1 ) get_byte( 1 ) ILIKE( 1 )

initcap( 1 ) length( 2 ) lower( 1 ) lpad( 1 ) ltrim( 3 ) Negation( 1 )

octet_length( 2 ) position( 2 ) RE Operator( 1 ) Regular Expression( 3 ) repeat( 1 ) rpad( 2 )

rtrim( 2 ) set_byte( 1 ) strpos( 1 ) substr( 6 ) substring( 3 ) to_ascii( 1 )

to_char( 7 ) to_number( 4 ) translate( 3 ) trim leading( 1 ) trim trailing( 1 ) trim( 2 )

upper( 1 )

Math Functions

abs( 2 ) asin( 1 ) atan( 1 ) atan2( 2 ) cbrt( 2 ) ceil( 4 )

cos( 1 ) cot( 1 ) degrees( 2 ) exp( 2 ) exponent( 2 ) floor( 2 )

isfinite( 1 ) ln( 3 ) log( 5 ) md5( 1 ) mod( 2 ) PI( 3 )

Pow( 2 ) Power( 4 ) radians( 1 ) random( 2 ) round( 3 ) setseed( 1 )

sin( 1 ) sqrt( 1 ) tan( 1 ) trunc( 3 )

User Previliege

User Previliege

Check Privilege( 1 ) Create User( 1 ) Current User( 1 ) current_user( 1 ) Drop User( 1 ) Group Privileges( 1 )

REVOKE Privileges( 1 ) session_user( 1 ) usecreatedb( 1 ) User Privileges( 1 )

www.java2java.com | Contact Us

Copyright 2010 - 2030 Java Source and Support. All rights reserved.

All other trademarks are property of their respective owners.