CODEWITHSUNDEEP
sqlpostgresqlplpgsql
Sherin Green
Sherin Green

Reputation: 358

How to trim double quotes from string variable in postgreSQL function

I have a function in postgreSQL,One of my function argument is text type variable and that enclosed with in double quotes so i want to insert this variable to table with out double quotes ,when i search regarding this on net i got a query like SELECT trim(both ' ' from 'techonthenet.com'); but this not working in the case of double quotes so how will i remove double quotes from text string variable in postgreSQL function

Upvotes: 12

Views: 20151

Answers (3)

user22576630
user22576630

Reputation: 21

SELECT TRIM('"Hello"', '"');

I used the above code to remove quotes from a column containing strings wrapped in double quotes:

SELECT trim(lower(content_category), '"') FROM Content;

Here I nested a function, lower, inside another function TRIM. IT WORKED FINE.

Upvotes: 2

Roman M
Roman M

Reputation: 12418

Another simple solution would be:

SELECT REPLACE('"Hello"', '"', '');

Upvotes: 3

Pavel Stehule
Pavel Stehule

Reputation: 45805

It is working:

postgres=# select '"Hello"';
┌──────────┐
│ ?column? │
╞══════════╡
│ "Hello"  │
└──────────┘
(1 row)

postgres=# select trim(both '"' from '"Hello"');
┌───────┐
│ btrim │
╞═══════╡
│ Hello │
└───────┘
(1 row)

Upvotes: 21

Related Questions