Postgres trim string

SELECT
	TRIM (
		LEADING
		FROM
			'  PostgreSQL TRIM'
	),
	TRIM (
		TRAILING
		FROM
			'PostgreSQL TRIM   '
	),
	TRIM ('  PostgreSQL TRIM  ');
Code language: SQL (Structured Query Language) (sql)

Source: postgresqltutorial.com

Postgres trim string

LTRIM(string, [character]);
RTRIM(string, [character]);
BTRIM(string, [character]);Code language: SQL (Structured Query Language) (sql)

Source: postgresqltutorial.com

Postgres trim string

SELECT
	TRIM (
		LEADING '0'
		FROM
			CAST (0009100 AS TEXT)
	); -- 9100Code language: SQL (Structured Query Language) (sql)

Source: postgresqltutorial.com

Similar codes

8 votes352 views1 answer
Mysql limit rows
SQL
1 vote299 views1 answer
How to see all table partition in oracle
SQL
0 vote324 views1 answer
What is the difference between the LIKE and REGEXP operators in mysql?
SQL
0 vote319 views1 answer
Mysql Digital Ocean connection problems
SQL
0 vote342 views1 answer
T-sql update table variale
SQL
0 vote345 views1 answer
Influxdb list all tags for a measurement
SQL
3 votes334 views1 answer
Locate sql server
SQL
2 votes306 views1 answer
Date_format for time sql
SQL
0 vote363 views1 answer
Psql create usr
SQL
1 vote330 views3 answers
What is union in sql
SQL