Thread: Few questions

Few questions

From
"Chris Boget"
Date:
Ok, so I listed out all the table using '\l'.  3 were
displayed:

  List of databases
   Name    |  Owner
-----------+----------
 template0 | postgres
 template1 | postgres
 test      | postgres
(3 rows)

However, when I did

\d test

It came back with the error:

Did not find any relation named "test".

Why?  Is the table not really there?  If that's the case,
why is it showing up with '\l'?

Also, I was reading through the documentation and I just
want to be clear what a "tuple" is.  Is it a row of data or
anything else in the singular that is returned by a query?

thnx,
Chris




Re: Few questions

From
Bruno Wolff III
Date:
On Mon, Nov 25, 2002 at 07:39:24 -0600,
  Chris Boget <chris@wild.net> wrote:
> Ok, so I listed out all the table using '\l'.  3 were

\l lists databases, not tables. Use \? to get information about \ commands.