public."returns"

[MrCBofBCinTX]

I moved a small mysql database to postgresql
Everything seems fine.
But when I list tables, I get the following:
[tt]
...
...
public."returns"
public.products
public.purchases
public.vendor
...
...
[/tt]

I was wondering why this table is double quoted?

Is this because RETURNS is SQL?
Will I need to take any special steps if that is the case?
I would rather change the tables name if it is going to complicate my life.
Thanks

 

[feherke]

Hi

I was wondering why this table is double quoted?

As listed in SQL Key Words, it is a non-reserved key word.

PostgreSQL by default quotes all key words. Being non-reserved, you can use [tt]returns[/tt] as identifier for your tables and fields.

Some SQL gurus are not recommending the use of any key word as identifier. Personally I am far to be a guru and I use them regularly.

Feherke.

http://rootshell.be/~feherke/