Re: New-B Question #2 - Mailing list pgsql-novice

From Philip Hallstrom
Subject Re: New-B Question #2
Date
Msg-id 20050823092952.S23844@wolf.pjkh.com
Whole thread Raw
In response to New-B Question #2  (cbraden <cbraden@douglasknight.com>)
Responses SQL problem?  (cbraden <cbraden@douglasknight.com>)
List pgsql-novice
> What I would like to do, use PostgreSQL and PHP, is list all the columns for
> a given table.  (Having finally choked the list of tables from postgre).  In
> MySQL it is something like this "SHOW COLUMNS FROM {tablename} FROM
> {databasename}".  I'm assuming I'm missing something obvious and bonehead,
> but I can't seem to translate that into postgreSQL to save my bacon.

See the example on this page:

http://us2.php.net/manual/en/function.pg-meta-data.php

-philip


pgsql-novice by date:

Previous
From: "Adam Bickford"
Date:
Subject: Removing PostGreSQL Services and Accounts
Next
From: Saranya Sivakumar
Date:
Subject: function to escape single quotes