[SQL] flat file database to postgres
Hi Does anybody know how to export data from a flatfile (using perl) database to postgres? Thanks ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
[Fwd: [SQL] unsubscribe]
Original Message Subject: [SQL] unsubscribe From:"U K Laxmi" <[EMAIL PROTECTED]> Date:Thu, May 26, 2005 1:52 pm To: "hatuan" <[EMAIL PROTECTED]> "Tom Lane" <[EMAIL PROTECTED]> Cc: -- __ Do you Yahoo!? Yahoo! Small Business - Try our new Resources site http://smallbusiness.yahoo.com/resources/ ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq ---(end of broadcast)--- TIP 8: explain analyze is your friend
[SQL] unsubscribe
please take me out from this group. ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org
[SQL] system time
is there any function from which i can get system time? Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
[SQL] time difference
i want to calculate the session time. my query is thisselect now() - '2001-05-19 12:09:00+5;it gives the difference in date and difference in time separately. if thecurrent time is greater than the second time then it gives simply theirdifference but i want to calcutate the session time from these two times.if now() = 2001-05-25 01:00:00+5 and second timestamp = 2001-05-24 23:00:00+5 then how can i get their time differernce EQUAL TO '3:00:00' instead of '21:00:00 ago' ? and is there a way to get the total time difference including the date factor involved i.e. if now() = 2001-05-25 23:00:00+5 and second timestamp = 2001-05-24 01:00:00+5then is there any function to get their difference equal to '46:00:00' instead of '1 22:00:00' ? please reply me soon.
