practicalli

https://practicalli.github.io/ http://yt.vu/+practicalli (youtube)
Oliver 2021-05-03T13:36:31.086800Z

@jr0cket In your banking app you have table names like PUBLIC.ACCOUNTS. What is the meaning of PUBLIC in these names?

practicalli-john 2021-05-03T15:52:42.086900Z

@oliver.heck Public is simply the default schema name in Postgres. If a schema is not specified when creating a table, it is placed under public https://www.postgresql.org/docs/9.1/ddl-schemas.html

Oliver 2021-05-03T15:57:47.088400Z

Ok, so will I need to mimic that if I want to change from H2 to Postgres later?

practicalli-john 2021-05-03T16:05:36.088500Z

I believe you can just specify a schema when using the sql create table function, so that hsql and Postgres are the same. Although I think hsqldb might also use public as the default schema. So if you only specify the table name, it will look in public by default. It's better to be explicit though. I'll need to check the code as to what I did exactly.

1👍
2021-05-03T16:58:58.088700Z

GitHub app is successfully upgraded in your workspace 🎉 To receive notifications in your private channels, you need to invite the GitHub app /invite @GitHub