3 ms·
No, index named are global in PostgreSQL and the SQL standard.
by jeltz 5y ago
No, index named are global in PostgreSQL and the SQL standard.
- electroly 5y agoThe ANSI SQL standard doesn't talk about indexes at all. I'm sure you're right about PostgreSQL; I'm no expert on that implementation. I took his post to be asking about SQL Server since that's what we were talking about in the subthread (hence my SQL Server-specific response). In SQL Server indexes are table-scoped.