i would like to select all the column from one table accept one column. so,
what is the SQL statement for it?

i am using a regular expression in a select statement inside a function.
how do i dynamically insert a variable into the regexp?
eg.  SELECT string ~ '\\d{X}'
where X is the dynamic variable.

inside my WHERE clause, i have a reg exp that uses a variable:
.....
.....
WHERE