Re: [SQL] Database Design tool

[Kevin Old]

Dan,

I use Xpga Java Postgresql client and it is awesome.

It's at http://www.kazak.ws/xpg/

Kevin

On Wed, 2002-10-30 at 10:30, Dan Hrabarchuk wrote:
> gASQL is a gnome-db client that looks like it has a lot of promise. The
> only problem is I've never been able to get the application to run
> properly. I'm using RedHat 8.0 on my desktop. The last official version
> does not install properly. If I grab a CVS copy, I go through dependency
> hell. Has anyone ever actually gotten gASQL to work?
> 
> Dan
> 
> On Wed, 2002-10-30 at 06:35, Johannes Lochmann wrote:
> > On Wed, 2002-10-30 at 07:45, Viacheslav N Tararin wrote:
> > 
> > Hi,
> > 
> > (which list should this go to? I guess it is OT on both...)
> >  
> > > Can anybody take me reference on Database design tool with PostgreSQL 
> > > support.
> > 
> > Dia and dia2sql (or something similar...) Google knows more :-)
> > 
> > HTH
> > 
> > Johannes Lochmann
> > 
> > 
> > ---(end of broadcast)---
> > TIP 2: you can get off all lists at once with the unregister command
> > (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
> 
> 
> 
> ---(end of broadcast)---
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
-- 
Kevin Old <[EMAIL PROTECTED]>


---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html

[SQL] Subtracting time fields

[Kevin Old]

Hello all,

I have two fields in my database access_time and release_time.I
would like to calculate the "duration" between these two values, but
can't figure out what to do.  

I've tried something like this but it doesn't work:

select access_time, release_time, time(access_time) - time(release_time)
as duration from mastertbl limit 10

Any suggestions?

Thanks,
Kevin
-- 
Kevin Old <[EMAIL PROTECTED]>


---(end of broadcast)---
TIP 6: Have you searched our list archives?

http://archives.postgresql.org