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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Summer,
take a look at the tables and views that are prefixed pg_ for the postgres
system data.
hih
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 sysobjects.id as tableid,
> syscolumns.id as columnid,
> sysobjects.name as tablename,
> syscolumns.name as colname,
> syscolumns.isnullable,
> syscolumns.autoval,
> syscolumns.colorder,
> syscolumns.length,
> systypes.name as typename
> from sysobjects,syscolumns,systypes
> where sysobjects.id = syscolumns.id and systypes.name <> 'sysname'
> and syscolumns.xtype=systypes.xtype
> and sysobjects.xtype='U'
> and sysobjects.name <> 'dtproperties'
> order by tablename,colorder
>
> Thanks,
>
>
> Summer S. Wilson ICQ 26835530
> Programmer/Analyst I, EIT TCE
> Webmaster, An Eclectic World (http://eclectic-world.com)
> Editor, EZLearnPhotography (http://www.ezlearnphotography.com)
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>
From | Date | Subject | |
---|---|---|---|
Next Message | Stephane Pinel | 2002-01-28 15:50:42 | [NEWBIE] Can't unpack RPMs |
Previous Message | Josh Berkus | 2002-01-27 18:32:14 | Re: pgadmin |