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

Re: [GENERAL] How can I obtain tables' structure?

From: Bob Dusek <bobd(at)palaver(dot)net>
To: Paul Mookhachov <paul(at)pmfd(dot)ru>
Cc: pgsql-general(at)postgreSQL(dot)org
Subject: Re: [GENERAL] How can I obtain tables' structure?
Date: 1998-12-08 22:18:30
Message-ID: Pine.LNX.3.96.981208170212.467M-200000@farout.palaver.net (view raw or flat)
Thread:
Lists: pgsql-general
Hey,

I did some messing around with this one night....

I haven't found anything comprehensive and totally conclusive, but I think
I made some progress that you may be able to build upon.

For all of those interested, I've attached some text that I wrote after I
was done "messing around."  I would happily take any commentary that might
be initiated by this...

Hope this helps,

Bob



On Mon, 7 Dec 1998, Paul Mookhachov wrote:

> Return-Path: <owner-pgsql-general(at)hub(dot)org>
> Received: from hub.org (majordom(at)hub(dot)org [209.47.148.200])
> 	by farout.palaver.net (8.9.1/8.9.1) with ESMTP id JAA29182
> 	for <bobd(at)palaver(dot)net>; Mon, 7 Dec 1998 09:07:05 -0500
> Received: from localhost (majordom(at)localhost)
> 	by hub.org (8.9.1/8.9.1) with SMTP id IAA06502;
> 	Mon, 7 Dec 1998 08:55:45 -0500 (EST)
> 	(envelope-from owner-pgsql-general(at)hub(dot)org)
> Received: by hub.org (TLB v0.10a (1.23 tibbs 1997/01/09 00:29:32)); Mon, 07 Dec 1998 08:45:37 +0000 (EST)
> Received: (from majordom(at)localhost)
> 	by hub.org (8.9.1/8.9.1) id IAA04424
> 	for pgsql-general-outgoing; Mon, 7 Dec 1998 08:45:34 -0500 (EST)
> 	(envelope-from owner-pgsql-general(at)postgreSQL(dot)org)
> Received: from trends.net (root(at)clio(dot)trends(dot)ca [209.47.148.2])
> 	by hub.org (8.9.1/8.9.1) with ESMTP id IAA04356
> 	for <pgsql-general(at)postgreSQL(dot)org>; Mon, 7 Dec 1998 08:45:20 -0500 (EST)
> 	(envelope-from paul(at)pmfd(dot)ru)
> Received: from pmfd.pmfd.ru (pmfd.pmfd.ru [194.8.185.65])
> 	by trends.net (8.8.8/8.8.8) with SMTP id FAA01679
> 	for <pgsql-general(at)postgreSQL(dot)org>; Mon, 7 Dec 1998 05:53:54 -0500 (EST)
> Received: from bridge.pmfd.ru by pmfd.pmfd.ru id aa27100; 7 Dec 98 11:37 MSK
> Message-ID: <366B9494(dot)DB7C5713(at)pmfd(dot)ru>
> Date: Mon, 07 Dec 1998 11:40:52 +0300
> From: Paul Mookhachov <paul(at)pmfd(dot)ru>
> Reply-To: paul(at)pmfd(dot)ru
> Organization: PMFD
> X-Mailer: Mozilla 4.5 [en] (WinNT; I)
> X-Accept-Language: ru
> MIME-Version: 1.0
> To: pgsql-general(at)postgreSQL(dot)org
> Subject: Re: [GENERAL] How can I obtain tables' structure?
> References: <F10BB1FAF801D111829B0060971D839F54EF3E(at)cpsmail>
> Content-Type: text/plain; charset=koi8-r
> Content-Transfer-Encoding: 7bit
> Sender: owner-pgsql-general(at)postgreSQL(dot)org
> Precedence: bulk
> 
> "Jackson, DeJuan" wrote:
> 
> > >
> > > > How can I obtain information about tables' structure and list of
> > > tables
> > > > using psql.lib or Pg.pm (perl package)?
> > >
> > >       all you have to do is to make a request likt this :
> > > 'select * from <table>' ($req = $cbase->exec ('select * from table'))
> > I'd use 'select * from <table> where false'. It save the table scan and
> 
> Well. I use same way. But may be I can do "select" from some system table?
> There are several tables called pg_*. They contain miscellaneous information,
> but I can't understand it.
> 
> ------------------------
> Paul E Mookhachov                  paul(at)pmfd(dot)ru
> System administrator of            phone: +7 /812/ 329-8102
> St-Petersburg Interbank            St-Petersbirg
> Financial House                    B.Zelenina st, 24
> 
> 


Attachment: pg_meta.txt
Description: text/plain (5.6 KB)

In response to

pgsql-general by date

Next:From: Sergei ChernevDate: 1998-12-09 04:03:19
Subject: Two problems
Previous:From: Bryan WhiteDate: 1998-12-08 21:56:19
Subject: Re: [GENERAL] Other user access to database

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