PostgreSQL examples (example source code) Organized by topic

1. PostgreSQL

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 /

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 /

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 /

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 /

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 /

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 /

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 /

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