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 vote159 views1 answer
Error in connection_import_file(conn@ptr, name, value, sep, eol, skip) : RS_sqlite_import: test.csv line 2 expected 11 columns of data but found 1
SQL
4 votes164 views2 answers
Sql server date now
SQL
0 vote182 views1 answer
Sql server on mac m1
SQL
0 vote158 views1 answer
Inner joint
SQL
0 vote168 views1 answer
Watch mysql command line
SQL
0 vote169 views1 answer
Python connect microsoft sql server
SQL
2 votes168 views1 answer
Oracle generated column
SQL
0 vote169 views1 answer
Mysql update privileges
SQL
0 vote172 views1 answer
Mysql db dump restore max file size issue
SQL
0 vote128 views2 answers
Jupyter notebook connect to database
SQL