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

Re: System info for Postgre

From: "Steve Boyle \(Roselink\)" <boylesa(at)roselink(dot)co(dot)uk>
To: "Summer S(dot) Wilson" <collectonian(at)eclectic-world(dot)com>, <pgsql-novice(at)postgresql(dot)org>
Subject: Re: System info for Postgre
Date: 2002-01-28 13:05:47
Message-ID: 001d01c1a7fc$80d4ee40$c55869d5@dualtower (view raw, whole thread or download thread mbox)
Lists: pgsql-novice

take a look at the tables and views that are prefixed pg_ for the postgres
system data.


steve boyle

----- Original Message -----
From: "Summer S. Wilson" <collectonian(at)eclectic-world(dot)com>
To: <pgsql-novice(at)postgresql(dot)org>
Sent: Friday, January 25, 2002 4:24 PM
Subject: [NOVICE] System info for Postgre

> Hi all,
> I am trying to create a system to let my users do some Ad Hoc querying of
> their database and I found a nifty program to do it.  Unfortunately it was
> written with a MS SQL database in mind (I guess) so I have no clue how to
> translate the SQL statements that pull tables and columns to one that
> PostgreSQL will understand.  I've posted it below...can anyone point me in
> the right direction for what translates to what?  This is the original SQL
> statement, which doesn't work in PostgreSQL.
> select as tableid,
> as columnid,
> as tablename,
> as colname,
>     syscolumns.isnullable,
>     syscolumns.autoval,
>     syscolumns.colorder,
>     syscolumns.length,
> as typename
> from   sysobjects,syscolumns,systypes
> where = and <> 'sysname'
>    and syscolumns.xtype=systypes.xtype
>    and sysobjects.xtype='U'
>    and <> 'dtproperties'
> order by tablename,colorder
> Thanks,
> Summer S. Wilson         ICQ 26835530
> Programmer/Analyst I, EIT TCE
> Webmaster, An Eclectic World  (
> Editor, EZLearnPhotography (
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?

In response to

pgsql-novice by date

Next:From: Stephane PinelDate: 2002-01-28 15:50:42
Subject: [NEWBIE] Can't unpack RPMs
Previous:From: Josh BerkusDate: 2002-01-27 18:32:14
Subject: Re: pgadmin

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