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

Switching from MySQL -- Missing DESCRIBE table, SHOW TABLES

From: Gan Uesli Starling <alias(at)starling(dot)us>
To: pgsql-novice(at)postgresql(dot)org
Subject: Switching from MySQL -- Missing DESCRIBE table, SHOW TABLES
Date: 2005-10-16 21:17:23
Message-ID: 4352C363.1060908@starling.us (view raw or flat)
Thread:
Lists: pgsql-novice
Hello,

I had employed MySQL for a couple of former projects. But now have 
decided to switch to PostgreSQL...not that version 8 also works on that, 
ahem...other OS...which I'm stuck with at work.

But alas, two of the most useful commands appear to be missing:

SHOW TABLES
DESCRIBE table

Inasmuch as my prototyping DB is on my NetBSD server at home while my 
data waiting to be 'based is at work...such that I have to connect via 
Perl/DBI and XML-RPC (not psql, alas). The IT dept here just says, "Use 
MS-Access", so no help there.

While I'm in the innitial stage I need an informative way to blunder 
around and see what's what as I try different ways to build this thing. 
For that I had always relied on the two above from MySQL.

I can't believe there is no way for PostgreSQL to tell me what the 
current DB's table structure is via simple SQL queries executed remotely.

Surely there must be. But I can't seem to find out from the couple of 
books I have. All I dug up was some ultra-lame hack to get column names 
for an already known table name by doing a "WHERE 1 != 1" or some such 
so that no actual rows could be returned. Not very informative, that. 
Surely I've missed the point, somewhere.

So enlighten me, please. What, pray tell, are the PostgreSQL-ish SQL 
queries one uses so as to explore a given DB's table structure? What is 
the PostgreSQL translation for "SHOW TABLES" and "DESCRIBE table"?

Thanks in advance,

Gan Starling
Kalamazoo MI

Responses

pgsql-novice by date

Next:From: Oliver ElphickDate: 2005-10-16 23:10:02
Subject: Re: Switching from MySQL -- Missing DESCRIBE table, SHOW
Previous:From: Ilias GoudaropoulosDate: 2005-10-16 20:59:27
Subject: 8.0.3 Anoying installer error

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