Re: [GENERAL] plpgsql , dynamic queries

2003-08-28 Thread Heath Tanner
It would be easier to help you with the quoting issues if you provided an example of the entire query you need to execute and/or the code you're using to build the query. Quoting in a function can get pretty hairy sometimes. You might find this chart helpful, I certainly have: http://www.postg

Re: [GENERAL] SQL Command - To List Tables ?

2003-08-28 Thread Heath Tanner
On Wednesday, August 27, 2003, at 09:17 AM, Carmen Gloria Sepulveda Dedes wrote: Hello. I type \dt as user postgres, but it show only the tables within public schema. I need to know all tables (like v$_ or dba_ or user_ in oracle). How I do that? Start psql with the echo flag: [inligo:~] h

Re: [GENERAL] Books for PostgreSQL?

2003-08-28 Thread Heath Tanner
Not to take anything away from the books on the topic, but my favorite source is the docs that got installed with postgres (/usr/local/pgsql/doc/html). The index isn't great, but easily overcome: grep -i "search phrase" /usr/local/pgsql/doc/html/* | less Try to do that with a book. :-) When I c