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: (view raw or whole 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:


In response to


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-2015 The PostgreSQL Global Development Group