Re: [SQL] graphical interface - admin

2002-07-01 Thread Andreas Joseph Krogh
On Friday 28 June 2002 17:30, Josh Berkus wrote: > David, > > > As for what I first said in this mail, I'll launch the development of > > a Kde > > application (I think called KPostgreSQL...), which will have to fit > > the > > following : > > Listen, the PGAdminII "team" (i.e. David Page) is plan

Re: [SQL] graphical interface - admin

2002-07-01 Thread Oleg Bartunov
On Mon, 1 Jul 2002, Andreas Joseph Krogh wrote: > > Take a look at TOra - Toolkit For Oracle: http://www.globecom.se/tora/ > > It has excellent PostgreSQL support. I tried 1.2.4 but didn't found how to configure tora to work with postgresql. > > Regards, Oleg

Re: [SQL] graphical interface - admin

2002-07-01 Thread Andreas Joseph Krogh
On Monday 01 July 2002 13:29, you wrote: > On Mon, 1 Jul 2002, Andreas Joseph Krogh wrote: > > Take a look at TOra - Toolkit For Oracle: http://www.globecom.se/tora/ > > > > It has excellent PostgreSQL support. > > I tried 1.2.4 but didn't found how to configure tora to work > with postgresql. I

Re: [SQL] graphical interface - admin

2002-07-01 Thread Oleg Bartunov
On Mon, 1 Jul 2002, Andreas Joseph Krogh wrote: > On Monday 01 July 2002 13:29, you wrote: > > On Mon, 1 Jul 2002, Andreas Joseph Krogh wrote: > > > Take a look at TOra - Toolkit For Oracle: http://www.globecom.se/tora/ > > > > > > It has excellent PostgreSQL support. > > > > I tried 1.2.4 but d

Re: [SQL] graphical interface - admin

2002-07-01 Thread Andreas Joseph Krogh
On Monday 01 July 2002 15:00, Oleg Bartunov wrote: > On Mon, 1 Jul 2002, Andreas Joseph Krogh wrote: > > On Monday 01 July 2002 13:29, you wrote: > > > On Mon, 1 Jul 2002, Andreas Joseph Krogh wrote: > > > > Take a look at TOra - Toolkit For Oracle: > > > > http://www.globecom.se/tora/ > > > > > >

Re: [SQL] graphical interface - admin

2002-07-01 Thread Roberto Mello
On Mon, Jul 01, 2002 at 02:29:27PM +0300, Oleg Bartunov wrote: > > I tried 1.2.4 but didn't found how to configure tora to work > with postgresql. Tora is very nice. I'm using 1.3.5 with PG 7.2 (Debian). I had to compile the PostgreSQL Qt 3 module for it to work. -Roberto -- +| http://fs

Re: [SQL] pl/pgsql capabilities?

2002-07-01 Thread Roberto Mello
On Mon, Jul 01, 2002 at 01:43:29AM +0200, Ferenc Engard wrote: > Hi all, > > A long time ago (at version 6.3.2 or what :) I have asked, but maybe > since it changed: can I use the procedural languages (any of them) to > return a table- (or view-) like output, just like in Interbase, for > example

[SQL] Using union to avoid creating temp table

2002-07-01 Thread Bruno Wolff III
I don't know if this is a well known trick or not. I wanted to check a list of values inputted to a script against some existing tables. I was trying to think of alternatives to using a temp table and copy since this would take two requests instead of one. What I ended up doing is building the in

[SQL] unsubscribe

2002-07-01 Thread Simeone, Mario
unsubscribe su www.tim.it puoi iscriverti gratis alle TimNews, un modo rapido e tempestivo per conoscere le ultime novita di TIM. ---

Re: [SQL] Using union to avoid creating temp table

2002-07-01 Thread Tom Lane
Bruno Wolff III <[EMAIL PROTECTED]> writes: > What I ended up doing is building the input values into sepearte > select statements unioned together. So if the input values were > 'abc', 'def' and 'ghi', I would end up doing a select like: > select add.id from (select 'abc' union select 'def' union

Re: [SQL] pg_restore cannot restore function

2002-07-01 Thread Jan Wieck
Jie Liang wrote: > > Oops,my OS is FreeBSD4.3 PostgreSQL7.2 I cannot see such an error message in the pg_restore sources at all. Are you sure to use the right versions together? Jan > > Thanks > > Jie Liang > > -Original Message- > From: Jie Liang > Sent: Friday, June 28, 2002 1:46

Re: [SQL] pl/pgsql capabilities?

2002-07-01 Thread Ferenc Engard
> > since it changed: can I use the procedural languages (any of them) to > > return a table- (or view-) like output, just like in Interbase, for > > example? E.g., if I have a metamodel and I want to write functions what > > perform complex computations and queries, can they return the result > >

Re: [SQL] pl/pgsql capabilities?

2002-07-01 Thread Roberto Mello
On Tue, Jul 02, 2002 at 01:37:08AM +0200, Ferenc Engard wrote: > > If I understand well, I can create a cursor for a SELECT statement, and > return that cursor. Well, it is better than nothing, but I fear it is > not flexible enogh for me. Maybe not for the solution you have right now, but you m