Thread: \list

Hi,

I'm quite new to PSQL , trying to list all tables available in a db called
"cgi" and here's what psql gives me back, using the interactive psql shell:

With \l or \list
cgi=> \list
ERROR:  parser: parse error at or near "("

with \d

cgi=> \d some_table
ERROR:  parser: parse error at or near "."

Select, update, insert... Those commands seems to do ok, but no \commands
seems to work.

Does someone know what can be  wrong with this?

Thanks

J"Poitras

Jos <jos@martiens.net> writes:
> I'm quite new to PSQL , trying to list all tables available in a db called
> "cgi" and here's what psql gives me back, using the interactive psql shell:

> With \l or \list
> cgi=> \list
> ERROR:  parser: parse error at or near "("

> with \d

> cgi=> \d some_table
> ERROR:  parser: parse error at or near "."

I think you are using a psql client that is much newer than the server
you are speaking to.  Generally you want to use a psql of the same
version as the server ...

            regards, tom lane

On Thu, Dec 01, 2005 at 12:08:23PM -0500, Jos wrote:
> I'm quite new to PSQL , trying to list all tables available in a db called
> "cgi" and here's what psql gives me back, using the interactive psql shell:
>
> With \l or \list
> cgi=> \list
> ERROR:  parser: parse error at or near "("

Do your client and server versions differ?  What does "psql --version"
show from the command line, and what does "SELECT version();" show from
within psql?

--
Michael Fuhr