Skip site navigation (1) Skip section navigation (2)

Re: New-B Question #2

From: Philip Hallstrom <postgresql(at)philip(dot)pjkh(dot)com>
To: cbraden <cbraden(at)douglasknight(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: New-B Question #2
Date: 2005-08-23 16:30:44
Message-ID: 20050823092952.S23844@wolf.pjkh.com (view raw or flat)
Thread:
Lists: 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


In response to

Responses

pgsql-novice by date

Next:From: Ennio-SrDate: 2005-08-24 01:01:21
Subject: Form to populate a pg table with data
Previous:From: Adam BickfordDate: 2005-08-23 13:25:30
Subject: Removing PostGreSQL Services and Accounts

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group