Re:PostgreSQL Schema Design
by edoceo on Sunday March 29, 2020 @03:19PM
(#22721779)
You have it backwards. Database is named "foo" and the default schema in PG is called "public". PG uses a schema search path. When you select from table you're really selecting from public.table. Cross schema queries like SELECT public.client.id, billing.ledger.amount FROM public.client JOIN billing.leger ON ....
[ Parent
| on HN ]
Re:PostgreSQL Schema Design
by ComputerGuru on Sunday March 29, 2020 @04:38PM
(#22722494)
Sorry, yes. Thanks for the correction!