Обсуждение: Problems to see the structure of a table

Hi,

After having some problems with our database server (in the hardware not
with postgres), when we execute '\d my_table' from psql it displays:

ERROR:  No such function 'format_type' with the specified attributes

We cannot execute the \dT command neither because it displays same
error. Could the reason be that some of the System files (as pg_type ,
etc.) are corrupted ?

How can we fix this problem ?

Any help will we apreciated.

Thanks,

Gabi :-)

Gabriel Fernandez <gabi@unica.edu> writes:
> After having some problems with our database server (in the hardware not
> with postgres), when we execute '\d my_table' from psql it displays:
> ERROR:  No such function 'format_type' with the specified attributes

Sounds to me like you are using a psql that is newer than your server.
Considerably newer, in fact, since format_type was added in 7.1 but
that error message hasn't been spelled that way since 6.5.

            regards, tom lane