Re: selecting tables and columns

Bob,
Use "\d"...

Take a look at the help using the \? from the postgres prompt...

:
:
Informational
\d [NAME] describe table, index, sequence, or view
\d{t|i|s|v|S} [PATTERN] (add "+" for more detail)
list tables/indexes/sequences/views/system tables
:
:

-----Original Message-----
From: pgsql-novice-owner(at)postgresql(dot)org
[mailto:pgsql-novice-owner(at)postgresql(dot)org] On Behalf Of Robert Morgan
Sent: Monday, June 07, 2004 8:37 PM
To: postgres
Subject: [NOVICE] selecting tables and columns

Hi does postgresql have a similar command to SHOW in MySQL.
I want to select all tables that match a criteria then select all columns.
from those tables.

in MySQL: "SHOW tables like 'stu%'";
"SHOW columns from ".$tbl." ";
using php variable

thanks
Bob

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match