PostgreSQL

PostgreSQL operator ||
 

PostgreSQL operator ||

PostgreSQL operator || allows combining 2 or more lines together. Syntax for || in PostgreSQL string1 || string2 || string_n Operator parameters and argumentsstring1 - The first line to...

SQLS*Plus - PostgreSQL LTRIM function 1
 

PostgreSQL LTRIM function

The PostgreSQL LTRIM function removes all specified characters on the left side of the line. Syntax of LTRIM function in PostgreSQL ltrim( string, trim_character ) Parameters and function...

SQLS*Plus - PostgreSQL lower function 1
 

PostgreSQL lower function

The PostgreSQL lower function converts all characters of a specified string into a lower case. Syntax of lower function in PostgreSQL lower( string ) Parameters and function arguments...

SQLS*Plus - PostgreSQL char length function 1
 

PostgreSQL char_length function

The char_length function in PostgreSQL returns the length of the specified string. Syntax of char_length function in PostgreSQL char_length( string ) Parameters and function arguments...

SQLS*Plus - PostgreSQL now function 1
 

PostgreSQL now function

The PostgreSQL now function returns the current time and date with the time zone. Syntax of the now function in PostgreSQL now ( ) Parameters and function argumentsThere are no...

SQLS*Plus - PostgreSQL localtimestamp function 1
 

PostgreSQL localtimestamp function

The localtimestamp PostgreSQL function returns the current date and time. Syntax of the PostgreSQL localtimestamp function localtimestamp( [ precision ] ) Parameters and function arguments...

SQLS*Plus - PostgreSQL extract function 1
 

PostgreSQL extract function

PostgreSQL extract function extracts parts from the date. Syntax of the extract function in PostgreSQL extract( unit from date ) Parameters and function argumentsdate - date, timestamp,...

PostgreSQL date_part function
 

PostgreSQL date_part function

PostgreSQL date_part  function extracts parts from the date. The syntax of the date_part function in PostgreSQL date_part( 'unit', date ) Parameters and function argumentsdate - Date,...

PostgreSQL current_timestamp function
 

PostgreSQL current_timestamp function

PostgreSQL current_timestamp function returns the current date and time with the time zone. Syntax of the current_timestamp function in PostgreSQL current_timestamp( [ precision ] ) Parameters...

SQLS*Plus - PostgreSQL current time function 1
 

PostgreSQL current_time function

The current_time function in PostgreSQL returns the current time with the time zone. Syntax of the current_time function in PostgreSQL current_time( [ precision ] ) Parameters and function...

PostgreSQL current_date function
 

PostgreSQL current_date function

The current_date function in PostgreSQL returns the current date. Syntax of current_date function in PostgreSQL current_date Parameters and function argumentsThere are no parameters or...

PostgreSQL function age
 

PostgreSQL function age

The PostgreSQL function age returns the number of years, months, and days between two dates. Syntax of the function age in PostgreSQL age( [date1,] date2 ) Parameters and function...

SQLS*Plus - PostgreSQL Alias 1
 

PostgreSQL Alias

PostgreSQL Alias can be used to create a temporary name for tables or columns. Column aliases are used to make it easier to read column headers in a set of results.Table aliases are used to...

PostgreSQL comments
 

PostgreSQL comments

Can you place comments in your SQL statements in PostgreSQL? These comments can appear in one line or cover several lines. Let's see how to do that.There are two syntaxes that you can use to...

PostgreSQL variables
 

PostgreSQL variables

In this tutorial, you will learn how to declare variables in PostgreSQL using syntax and examples. What is a variable in PostgreSQL? In PostgreSQL, a variable allows a programmer to temporarily...

SQLS*Plus - PostgreSQL data types 1
 

PostgreSQL tutorial: PostgreSQL data types

Below is a list of data types available in PostgreSQL, which includes string, numeric, and date/time type. String data types Below are String data types in PostgreSQL :Syntax of data...

 
5