Re: BUG #14200: Cannot create a table named 'user'

On Saturday, June 18, 2016, <liveloveprosper@gmail.com> wrote:

> The following bug has been logged on the website:
>
> Bug reference:      14200
> Logged by:          Matthew Di Pasquale
> Email address:      liveloveprosper@gmail.com <javascript:;>
> PostgreSQL version: 9.5.3
> Operating system:   OS X 10.11.5
> Description:
>
> Problem:
> http://stackoverflow.com/q/22256124


Not a bug.

And it was asked and answered, correctly, two years ago.


> Why doesn't the user table have the pg_ prefix or some other prefix?


You should read that SO post again...

It does.  Check the docs for proof.  Or just try <select * from user> in
newly created database.  Then try <select * from pg_user>.


> What if I want to create a user table for my application? Shouldn't I be
> able to call that table user?


If you quote it you can.  But as the SO answer advises just live with the
fact it's not a recommended approach.


>
> Would the only reason to use table name prefixes be to avoid this
> conflict?
>
>
http://stackoverflow.com/questions/324163/should-we-use-prefixes-in-our-database-table-naming-conventions#comment61629636_324183
>
>
Don't know what you are asking for here...

David J.