Re: [SQL] date

2002-10-18 Thread wishy wishy
hi folks, we have a PostgreSQL 7.2.2 on i686-pc-linux-gnu, compiled by GCC 2.96 installation on pogo linux 7.2 we are facing a data problem when we do the following select to_char(to_date('1969-10-22','-MM-DD'),'-MM-DD'); ERROR: Unable to convert date to tm we have been trying to find a

Re: [SQL] foreign keys again

2002-10-18 Thread wishy wishy
hi folks, For a certain table A, I need to find out the names of the columns who have a foreign key to a specific table B using the catalog.Has anyone done this before entirely using pgsql.I have been through the archieves and have not been able to find the required information. thanks kprasad