> I'm new with postgresql. How can i show table name and db name in
> postgresql like SHOW TABLE and SHOW DATABASE in MySQL.
The equivalent of SHOW TABLE foo; in pg would be:
\d foo
Note that there is no ; at the end of that command.
I'm not sure what's equivalent to SHOW DATABASE.