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

-1 vote218 views1 answer
Mysql #1064 error
SQL
0 vote217 views1 answer
Sqlalchemy sequence postgresql
SQL
34 votes212 views6 answers
Install mysql client ubuntu
SQL
0 vote200 views1 answer
Oracle activate program
SQL
0 vote232 views1 answer
Mysql config address
SQL
1 vote222 views4 answers
Psql: error: FATAL: database "odoo" does not exist
SQL
2 votes237 views2 answers
Postgresql get table names
SQL
2 votes219 views1 answer
Oracle calculated column
SQL
0 vote175 views1 answer
Postgres delete where id in
SQL
0 vote224 views1 answer
Is not numeric sql
SQL