PostgreSQL examples (example source code) Organized by topic

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

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