[GENERAL] problem in connecting to postgreserver

Sir,   I have installed postgres in my standalone pc and PGAdmin -III,i am able to start postgresql server and it is running,but when i try to connect to postgreserver from pgadmin i am geting   Error connecting to server   Is the server running on host 127.0.0.1 and accepting TCP/IP connections on

Re: [GENERAL] How to debug pl/pgSQL -script?

Hi, http://www.postgresql.org/docs/7.4/static/plpgsql-errors-and-messages.html Albert ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [GENERAL] Listing views

On Tuesday 10 August 2004 03:14, Olivier Guilyardi wrote: > SELECT viewname FROM pg_views WHERE viewname !~ '^pg_'; with 7.4 : SELECT viewname FROM pg_views WHERE schemaname NOT IN ('pg_catalog','information_schema'); Albert ---(end of broadcast)-