[ADMIN] New cygwin includes Postgresql 7.1-2!?

2001-04-20 Thread lbottorff
I just installed the latest cygwin 1.1.8 on my NT 4.0 and apparently it also installed some/all of 7.1--or am I imagining things? I downloaded to a directory and then installed (default everything) and apparently Postgres came along for the ride! Does anyone know exactly what's happening here (is

[ADMIN] Re: System Catalogs

2001-04-20 Thread Joel Burton
On Fri, 20 Apr 2001 [EMAIL PROTECTED] wrote: Questions like this are better suited to pgsql-novice or pgsql-general than to the -admin list. > Finally, is there any place where I can find some system catalogs query examples? Run psql with -E and you can see the system queries given by psql.

[ADMIN] RServ help

2001-04-20 Thread Robert . Farrugia
Hi to all, I have installed the replication program rserv for postgres, but have not managed to make it replicate changes from master to slave. Anyone has any success ? Are there any documentation sites about rserv ? Thanks alot Robert ---(end of broadcast)---

[ADMIN] System Catalogs

2001-04-20 Thread tankgirl
Hi everyone, I wonder how can I deal with the System Catalogs. I want to know how to get simple information - like the tables defined in a database - out of them. Finally, is there any place where I can find some system catalogs query examples? Stay Safe & Happy :* TankGirl

Re: [ADMIN] Help with postgres functions

2001-04-20 Thread Karel Zak
On Thu, Apr 19, 2001 at 10:04:42AM -0300, Fabio Alberto Sobral wrote: > Dear Sirs, > >I have a timestamp atribute in my table and I want to get only the date of > this atribute. How can I do this? Does the extract or date_part functions > resolve my problem? Cast timestampt to date: