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