Brilliant! worked first time. pg_class is the one!
I know that you can get the types from a database from the metadata, but I'm
wondering if there is also a way to issue to an SQL query to postgres that will
yield the same result.
Herouth Maoz wrote:
> At 14:52 +0300 on 25/05/1999, Alex Turner wrote:
> > however.. is it possible to open a connection to the database and
> > determine what tables are in the database already?
> Of course. It's a query, just like any other query, but you select the data
> from the system catalogs rather than your own tables. Take a look in the
> documentation - the manpage for "catalogs".
> The table you should query is probably pg_class.
> Herouth Maoz, Internet developer.
> Open University of Israel - Telem project
In response to
pgsql-interfaces by date
|Next:||From: Byron Nikolaidis||Date: 1999-05-25 14:02:34|
|Subject: Re: [INTERFACES] MSAccess problem deleting rows|
|Previous:||From: Herouth Maoz||Date: 1999-05-25 13:08:31|
|Subject: Re: [INTERFACES] Retreiving Table info|