Le 2005 10 26 09:36, Martijn van Oosterhout a ecrit:
> On Tue, Oct 25, 2005 at 11:25:22AM -0700, Cosmopo wrote:
> > Hello,
> >
> > We are presently experimenting with Postgresql schemas... We used basic
> > commands like \d to list info from all tables/sequence/owner in a
> > db... The schema info was always "public" since we never created one...
>
> \dn list schemas
> \dt *.* list all tables in all schemas
> \z *.* list priveledges for all tables in all schemas
> etc...
>
> Is this helpful?
Hello,
Yes and no... The \dn does not list the schemas... I thinks it's my old
Postgresql version (7.3.2 and 7.3.4)... But \z does the trick...
It's a sign that it's time to upgrade... 8-)
Thanks
--
Mark
~~~~~~~~~~~~~~
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
