Martijn I still can't figure out how to use the select XXXX rdb$relations.
what I want is the output of

show tables country

which is this:-

COUNTRY (COUNTRYNAME) VARCHAR(15) Not Null
CURRENCY VARCHAR(10) Not Null
CONSTRAINT INTEG_2:
Primary key (COUNTRY)


select * from rdb$relations where rdb$relation_name='country'

give me this:-

RDB$VIEW_BLR RDB$VIEW_SOURCE RDB$DESCRIPTION RDB$RELATION_ID RDB$SYSTEM_FLAG
RDB$DBKEY_LENGTH RDB$FORMAT RDB$FIELD_ID RDB$RELATION_NAME
RDB$SECURITY_CLASS RDB$EXTERNAL_FILE RDB$RUNTIME RDB$EXTERNAL_DESCRIPTION
RDB$OWNER_NAME RDB$DEFAULT_CLASS RDB$FLAGS

================= ================= ================= ===============
=============== ================ ========== ============
=============================== ===============================
===============================================================================
================= ========================
=============================== ===============================
=========

<null> <null> <null> 128
0 8 1 2 COUNTRY
SQL$COUNTRY <null>



6:1e5 <null> SYSDBA
SQL$DEFAULT2 1
==============================================================================
RDB$RUNTIME:
BLOB display set to subtype 1. This BLOB: subtype = 5

==============================================================================


The rdb$relations doesn't give me the info I want.

On 3/2/06, Martijn Tonies <m.tonies@...> wrote:
>
>
> Hi,
>
> > I would like to get some info on some table through python-kinterbasdb
> but
> > it doesn't support the "show" statement. Any alternatives ?
>
> selecting "stuff" from rdb$relations and the like.
>
>
> Martijn Tonies
> Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
> Server
> Upscene Productions
> http://www.upscene.com
> My thoughts:
> http://blog.upscene.com/martijn/
> Database development questions? Check the forum!
> http://www.databasedevelopmentforum.com
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>
>
>
>


--
And whoever does an atom's weight of evil will see it.


[Non-text portions of this message have been removed]