Re: selecting tables and columns - Mailing list pgsql-novice

From Loftis, Charles E
Subject Re: selecting tables and columns
Date
Msg-id 25DC89BACF65D549BA045B806348C65E01AAF681@ushem201.exse01.exch.eds.com
Whole thread Raw
In response to selecting tables and columns  (Robert Morgan <robert_@ihug.co.nz>)
List pgsql-novice
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@postgresql.org
[mailto:pgsql-novice-owner@postgresql.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

pgsql-novice by date:

Previous
From: "Scott Marlowe"
Date:
Subject: Re: selecting tables and columns
Next
From: "Loftis, Charles E"
Date:
Subject: Built-in functions - does an obect exist...