Re: dictionary? - Mailing list pgsql-novice

From Ray Stell
Subject Re: dictionary?
Date
Msg-id 20060922202525.GA12074@cns.vt.edu
Whole thread Raw
In response to Re: dictionary?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: dictionary?
Re: dictionary?
List pgsql-novice
ok, how would I find out the path for any given stuff.  How would I
have related sql_features to information_schema having forgot that is
was information_schema?

THX.



On Fri, Sep 22, 2006 at 04:00:17PM -0400, Tom Lane wrote:
> Ray Stell <stellr@cns.vt.edu> writes:
> > template1=# \d sql_features
> > Did not find any relation named "sql_features".
>
> That's because it's not in your search_path.  This would work:
>
> regression=# \d information_schema.sql_features
>              Table "information_schema.sql_features"
>       Column      |               Type                | Modifiers
> ------------------+-----------------------------------+-----------
>  feature_id       | information_schema.character_data |

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: dictionary?
Next
From: Sean Davis
Date:
Subject: Re: dictionary?