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

0 vote347 views3 answers
Run sql command line
SQL
1 vote337 views2 answers
Postgresql remote connect
SQL
0 vote314 views1 answer
Sqlite closes value
SQL
0 vote314 views1 answer
Postgresql log
SQL
0 vote330 views1 answer
Get db connection detail from sql developer profile
SQL
0 vote333 views1 answer
Can we rollback in sql
SQL
0 vote329 views1 answer
How to alter length character varying postgres
SQL
11 votes311 views2 answers
Import sql file laravel cmd
SQL
1 vote336 views1 answer
Search for replace in mysql
SQL
0 vote331 views3 answers
Sql server import json
SQL