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 vote130 views1 answer
Typeorm raw sql
SQL
0 vote129 views1 answer
Postgres change the name of schema
SQL
0 vote149 views1 answer
How to define a non primary composite key in sql
SQL
2 votes125 views5 answers
Install postgresql 10 centos 7
SQL
4 votes109 views1 answer
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.s
SQL
-1 vote115 views1 answer
How to create foreign key in sql server management studio
SQL
20 votes108 views3 answers
SQL query rename table
SQL
1 vote98 views1 answer
How to get mysql db size
SQL
0 vote109 views1 answer
Find how many table doesn't contain column in mysql
SQL
0 vote116 views1 answer
Connect by query in oracle
SQL