Re: [SQL] Object description at Client Window

give psql -E a try.. It will display any internal SQL commands that it uses. Jordan S. Jones Kumar wrote: Dear Friends,   I am working with Postgres 7.3.4 on RH linux 7.2.   I could get into the command prompt to describe a table structure.   Welcome to psql, the

Re: [SQL] Postgres with OpenSSL

And http://www.postgresql.org/docs/7.3/static/client-authentication.html Jordan Jordan S. Jones wrote: http://www.postgresql.org/docs/7.3/static/ssl-tcp.html Jordan S. Jones -- I am nothing but a poor boy. Please Donate.. https://www.paypal.com/xclick/business=list%40racistnames.com&no_no

Re: [SQL] Postgres with OpenSSL

http://www.postgresql.org/docs/7.3/static/ssl-tcp.html Jordan S. Jones -- I am nothing but a poor boy. Please Donate.. https://www.paypal.com/xclick/business=list%40racistnames.com&no_note=1&tax=0¤cy_code=USD 2000info wrote: Hello, peopleware !!! I need to use Postgres with Open

Re: [SQL] returning composite types.

Here is how I have been doing mine: CREATE FUNCTION "myFunction" () RETURNS SETOF mytype AS ' DECLARE     r      mytype%ROWTYPE; BEGIN     FOR r IN [SELECT STATEMENT]     LOOP        RETURN NEXT r;     END LOOP;     RETURN; END; ' LANGUAGE 'plpgsql'; Hope