Patrick Nelson wrote:
----------------->>>>
Jean-Luc Lachance wrote:
----------------->>>>
Double up on the back slashes.
SELECT * FROM secure WHERE ~ '^12\\.'
----------------->>>>
That didn't work either...
----------------->>>>
Actually that does work within psql. I was trying from the command line
like:
psql <database> -c "SELECT * FROM <table> WHERE host~'^12\\.'"
which doesn't work. However, if I went into psql and entered the query then
it did work. Guess the bash shell does something to the block...