[SQL] Re: Passing table names to PL/PGSQL for SELECT/UPDATE/INSERT

2001-03-04 Thread Richard Huxton
Gerald Gutierrez wrote: > > I'd like to generalize my function. As per Richard Huxton's suggestion to > create tables named after session ID (thanks Richard)s, I'd like to pass in > some table names so that the algorithm can read from and write into tables > that I specify as parameters to the fu

Re: [SQL] Two way encryption in PG???

2001-03-04 Thread David Olbersen
On Sun, 4 Mar 2001, Boulat Khakimov wrote: ->How do I encrypt/decrypt something in PG? Perhaps it'd be better to one-way encrypt something? Granted I don't know the details of your project, but allowing a way to "decrypt" something is rather insecure. -- Dave ---(end o

[SQL] Re: From mailing list: PL/PGSQL returning recordset

2001-03-04 Thread Josh Berkus
Gerald, > I was searching for a way to return a recordset from PL/PGSQL (to implement > Dijkstra's algorithm) when I came upon your post at: > You mentioned that you posted a "workaround", but I've been unable to find > it with much searching. I may not be looking in the right place. Can you > p

Re: [SQL] Passing table names to PL/PGSQL for SELECT/UPDATE/INSERT

2001-03-04 Thread Gerald Gutierrez
I've found the discussion to which you have referred: http://www.postgresql.org/mhonarc/pgsql-sql/2001-02/msg00157.html but was unable to find the documentation for the EXECUTE command. From the discussion it seemed to me that doing an "INSERT" into a table of variable name cannot be done now

[SQL] Two way encryption in PG???

2001-03-04 Thread Boulat Khakimov
Hi, Im porting my software from mySQL to PG. I need to encypt a field in a table using two way encription. In mySQL for those purposes I was using build-in functions ENCODE/DECODE, is there such an equivalent in PG? How do I encrypt/decrypt something in PG? Regards, Boulat ---

[SQL] How to describe a field in the table ???

2001-03-04 Thread Boulat Khakimov
Hi, Im porting my programs from mySQL to PG. mySQL supports a query "DESCRIBE tablename fieldname" , that provides a detailed description of a specific table field. Is there such an equivalent in PG? "\d tablename" gives description for all the fields in the table, however I need to find out a