Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

public."returns"

Status
Not open for further replies.

MrCBofBCinTX

Technical User
Dec 24, 2003
164
0
0
US
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
 
Hi

MrCBofBCinTX said:
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top