sqlpostgresqlplpgsql

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

Solution

  • It is working:

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

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