[SQL] pg_dump backwards compat issues

Hi all, anybody have a sed script (or flags for pg_dump) that will make a pg_dump 7.4 dump load into a Pg 7.3.x backend? TIA! --- Thomas Good e-mail: [EMAIL PROTECTED] Programmer/Analyst

Re: [SQL] What day is it - when it isn't NOW()?

On Fri, 1 Aug 2003, Josh Berkus wrote: > Thomas, > > > than now()? I'm looking for something along the lines of: > > SELECT to_char('2003-08-04', 'Day') without much success. > > > > Well, you could try the online docs under "Functions and operators" . Hey Josh, how goes...yeah I bumbled around

[SQL] What day is it - when it isn't NOW()?

Hi, SELECT to_char(now(), 'Day'); returns Friday as I'd hoped. But how do I return the day of the week for a specific date other than now()? I'm looking for something along the lines of: SELECT to_char('2003-08-04', 'Day') without much success. Can anyone point me to the right function/combinat