Re: list all columns in db

From: Rodrigo De León <rdeleonp(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: list all columns in db
Date: 2007-06-07 22:34:26
Message-ID: 1181255666.295148.167400@p47g2000hsd.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Jonathan Vanasco ha escrito:
> Does anyone have a trick to list all columns in a db ?

SELECT *
FROM INFORMATION_SCHEMA.COLUMNS

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jon Sime 2007-06-07 22:36:07 Re: list all columns in db
Previous Message Tom Lane 2007-06-07 22:33:48 Re: index vs. seq scan choice?