Re: [SQL] RULES on SELECT with JDBC/perlDBI from other RDBMS products?

2005-10-07 Thread Richard Huxton
Bath, David wrote: Folks, I'm looking at using pg to be the main platform for integrating info from other RDBMS products (particularly Oracle) as pg seems to be the most flexible RDBMS around. Disregarding writing to foreign products, query-plan efficiencies, or differences of SQL dialect, I'd

Re: [SQL] How to delete Large Object from Database?

2005-10-07 Thread Richard Huxton
Premsun Choltanwanich wrote: Dear All, I use '$libdir/lo' for manage my PostgreSQL Large Object. It work fine for me to get and put Large Object from and to database. However I found something that may not correct when I try to backup my data. It seem that I cannot delete Large Object from

Re: [SQL] RULES on SELECT with JDBC/perlDBI from other RDBMS

2005-10-07 Thread Sean Davis
On 10/6/05 9:07 PM, "Bath, David" <[EMAIL PROTECTED]> wrote: > Folks, > > I'm looking at using pg to be the main platform for integrating info > from other RDBMS products (particularly Oracle) as pg seems to be > the most flexible RDBMS around. > > Disregarding writing to foreign products, query

Re: [SQL] using pg_tables and tablename in queries

2005-10-07 Thread solarsail
Thanks for the help everyone. I got everything working. The query I was orignally looking for was something like this: SELECT * from mytable WHERE pg_tables.tablename IN ( select tablename from pg_tables where tablename like 'mytable _%' ) It turns out that isn't what I really