I found a way to do this using regular expressions. Found this on
another website
CREATE OR REPLACE FUNCTION strip_tags(TEXT) RETURNS TEXT AS $$
2SELECT regexp_replace(regexp_replace($1, E'(?x)<[^>]*?(\s alt \s* =
\s* ([\'"]) ([^>]*?) \2) [^>]*? >', E'\3'), E'(?x)(< [^>]*? >)', '',
'g')
3$
Check out DB Solo ...
http://www.dbsolo.com/
Does both DDL compare as well as data compare.
From: pgsql-sql-ow...@postgresql.org [pgsql-sql-ow...@postgresql.org] On Behalf
Of manuel antonio ochoa [manuel8aalf...@gmail.com]
Sent: Wednesday, February 23, 2011 6:
How Can I do to compare two structures of data bases ?
DBA != DBB I need wich functions and wich tables are not equals
thnks
I have the following function that I used in MSSQL. I would like to
create the same function in PostgreSql. I think I am a bit confused on
how to create and set variables in PostgreSql. Can someone give me a
place to start to create something like this?
Thanks
Pam
SET ANSI_NULL
On 02/22/2011 04:18 PM, Adrian Klaver wrote:
On Tuesday, February 22, 2011 12:26:41 pm John Fabiani wrote:
> Hi,
> I would have thought that there would be a simple built-in function that
> would escape the quotes as ('D' Andes') to ('D\' Andes'). But I did not
> see anything?
>
> I a
