0

I use database.table_name only in Postgre SQL everytime i want to select a data from a table which is slightly annoying. Is there anyway to no use that and still run by queries without error

For ex in postgre SQL:

SELECT * 
FROM database.table_name

whereas in mysql:

SELECT *
FROM table_name

Haven't tried any different approach

jarlh
  • 42,561
  • 8
  • 45
  • 63
Anish Deshpande
  • 1
  • https://stackoverflow.com/questions/44429178/change-default-schema-for-user – jarlh Aug 25 '23 at 10:17
  • 1
    Duplicate of [Change default schema for user](https://stackoverflow.com/questions/44429178/change-default-schema-for-user) – esqew Aug 25 '23 at 10:25

0 Answers0