Re: [personal] Re: How to out \df to a file

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Craig <craig(at)mysoftforge(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: [personal] Re: How to out \df to a file
Date: 2009-04-01 14:56:01
Message-ID: 200904011456.n31Eu1c03129@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Craig wrote:
> Bruce,
>
> Thanks for your quick reply! Between your response and George's I was able
> to get exactly what I needed.
> That "-E" is a wonderful option. I have already put it into my snippets
> file!

I think the \o idea is best if you want something that will be
consistent from Postgres release to Postgres release because we
internally adjust the \df query occasionally to match changes in the
system tables.

Also, in 8.4, you might need \dfS because we are going to display only
user-created objects by default, unless 'S' or a pattern is supplied.

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Michael Lush 2009-04-01 15:08:35 grouping by time interval
Previous Message Craig 2009-04-01 14:53:44 Re: [personal] Re: How to out \df to a file