Postgres Pro
Downloads
Home   >   mailing lists

Re: newbie question... how do I get table structure? - Mailing list pgsql-general

From Richard Huxton
Subject Re: newbie question... how do I get table structure?
Date
Msg-id 200402061542.15214.dev@archonet.com
Whole thread Raw
In response to Re: newbie question... how do I get table structure?  (Franco Bruno Borghesi <franco@akyasociados.com.ar>)
List pgsql-general
Tree view 
On Friday 06 February 2004 15:00, Franco Bruno Borghesi wrote:
>
> Does anyone know if the ansi sql standard defines any way to do this?
> I've seen the DESCRIBE TABLE/INDEX/... or SHOW TABLE/INDEX/... commands
> in other databases, but I don't really know if they are extensions or
> not.

There's the new information schema, which displays standard info in 7.4 -
support elsewhere is variable I believe.

--
  Richard Huxton
  Archonet Ltd

pgsql-general by date:

Previous
From: "Andy Kriger"
Date:
Subject: how can I select into an array?
Next
From: Richard Huxton
Date:
Subject: Re: Run 2 versions of Postgresql on one machine?