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

Re: Table Meta-Data

From: "Brandon Aiken" <BAiken(at)winemantech(dot)com>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Table Meta-Data
Date: 2007-01-25 15:03:36
Message-ID: F8E84F0F56445B4CB39E019EF67DACBA44F525@exchsrvr.winemantech.com (view raw or flat)
Thread:
Lists: pgsql-novice
The information is also available through system views and system
catalogs:
http://www.postgresql.org/docs/8.2/interactive/catalogs.html



--
Brandon Aiken
CS/IT Systems Engineer

-----Original Message-----
From: pgsql-novice-owner(at)postgresql(dot)org
[mailto:pgsql-novice-owner(at)postgresql(dot)org] On Behalf Of A. Kretschmer
Sent: Thursday, January 25, 2007 9:58 AM
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: [NOVICE] Table Meta-Data

am  Thu, dem 25.01.2007, um  7:38:35 -0600 mailte Greg Lindstrom
folgendes:
> Hello,
> 
> I am running Postgres 8.0 on a Gento Box and would like to access the 
> information about the tables in my database.  How do I access the
column 
> names, data types, comments, etc?

Inside psql you can use \d table and some other commands, listed with
\?.

If you start psql with -E, you can see the underlaying SQL-commnds to
retrieve this informations.


Andreas
-- 
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47150,   D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID:   0x3FFF606C, privat 0x7F4584DA   http://wwwkeys.de.pgp.net

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
       choose an index scan if your joining column's datatypes do not
       match


--------------------------------------------------------------------
** LEGAL DISCLAIMER **
Statements made in this email may or may not reflect the views and opinions of Wineman Technology, Inc.
This E-mail message and any attachments may contain legally privileged, confidential or proprietary information. If you are not the intended recipient(s), or the employee or agent responsible for delivery of this message to the intended recipient(s), you are hereby notified that any dissemination, distribution or copying of this E-mail message is strictly prohibited. If you have received this message in error, please immediately notify the sender and delete this E-mail message from your computer.

QS Disclaimer Demo. Copyright (C) Pa-software.
Visit www.pa-software.com for more information.


In response to

pgsql-novice by date

Next:From: Duncan GarlandDate: 2007-01-25 15:09:57
Subject: Re: Table Meta-Data
Previous:From: A. KretschmerDate: 2007-01-25 14:57:48
Subject: Re: Table Meta-Data

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