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

Re: PostgreSQL 7.4.2 new tables [Stupid Query]

From: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
To: aspire420(at)hotpop(dot)com
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: PostgreSQL 7.4.2 new tables [Stupid Query]
Date: 2004-03-20 14:23:28
Message-ID: 20040320061719.N5996@megazone.bigpanda.com (view raw or flat)
Thread:
Lists: pgsql-novice
On Sat, 20 Mar 2004, V i s h a l Kashyap @ [Sai Hertz And Control Systems] wrote:

> Dear all,
>
> Just migrated to PostgreSQL 7.4.2 from 7.3.4
>
> I found that  after migration to 7.4.2  some of the tables in my
> database  which were not  created by me exists their
> Namely :
> 1. information_schema.sql_features
> 2. information_schema.sql_implementation_info
> 3. information_schema.sql_languages
> 4. information_schema.sql_packages
> 5  information_schema.sql_sizing
> 6. information_schema.sql_sizing_profiles
>
> These tables are viewable only with the psqlODBC connected clients i.e
> when I connect to database with
> psqlODBC then only these tables are viewable.

> My Stupid question is  :
> 1. Is this normal.
> 2. If this is normal then what are these tables for ?

It's part of the SQL spec.  It's the standard way to get information
about the database.

For example, from information_schema.sql_features, you can determine
things like, we support LEFT OUTER JOIN but not CUBE and ROLLUP. From
sql_implementation_info you can see things like the fact that NULLs are
treated as greater than non-nulls for sorting purposes.  From tables
(which isn't mentioned above, but should exists) you can see table names
and whether they are base tables or views.

They're not generally as powerful as going to the pg_* tables (some
details are likely to be left out), but they're standard.

In response to

pgsql-novice by date

Next:From: Jay DavisDate: 2004-03-20 21:32:08
Subject: How do you do a negative join?
Previous:From: V i s h a l Kashyap @ [Sai Hertz And Control Systems]Date: 2004-03-20 07:31:03
Subject: PostgreSQL 7.4.2 new tables [Stupid Query]

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