[DB-SIG] postgres access to db structure

Federico Di Gregorio fog@mixadlive.com
26 May 2001 15:24:03 +0200

On 26 May 2001 23:04:15 +1000, Dave Cole wrote:
> >>>>> "fve" == Frederic Vander Elst <fve@phgroup.com> writes:
> fve> I believe there is a platform-independent way of doing this :
> fve> select * from mytable where 1=0
> fve> from my experience, this works via mxODBC against db2, oracle,
> fve> postgres, and vfox tables types of dbs.
> It also works for my Sybase module.

works in psycopg too, but sometimes you don't know 'mytable', e.g., when
you're writing a db management tool that need the full list of tables,

Federico Di Gregorio
MIXAD LIVE Chief of Research & Technology              fog@mixadlive.com
Debian GNU/Linux Developer & Italian Press Contact        fog@debian.org
  Debian. The best software from the best people [see above]
                                      -- brought to you by One Line Spam