Re: Confusing terminology

Roderick A. Anderson writes:
>
> On Fri, 18 Jan 2002, Mike Mascari wrote:
>
> > What about "relation" vs. "table"?
> >
> > CREATE TABLE foo(key integer);
> >
> > ERROR: Relation 'foo' already exists
>
> Can a table named foo and a view named foo exist in the same database?
>
>
> Cheers,
> Rod

No. There's no reasonable way for the server to know which you mean when you
execute a statement. This applies to tables, views, sequences, etc.