[Evergreen-general] Cannot find PosrgeSQL relations
Rogan Hamby
rogan.hamby at equinoxoli.org
Sun Nov 10 12:44:20 EST 2024
Hi Dashamir,
Getting used to the database/schema/table structure of postgres is a bit of
adjustment from database/tables. As you explore Evergreen you'll see that
the schemas are used largely for logical grouping so, say, the action
schema holds tables, views and functions related to actions such as circs
and holds.
Have fun learning!
On Sat, Nov 9, 2024 at 7:53 AM Dashamir Hoxha via Evergreen-general <
evergreen-general at list.evergreen-ils.org> wrote:
> On Sat, Nov 9, 2024 at 1:42 PM Jason Stephenson via Evergreen-general <
> evergreen-general at list.evergreen-ils.org> wrote:
>
>>
>> \dt action.*
>>
>> Hope that helps,
>>
>
> Thanks, it helps a lot.
> In MariaDB a database contains tables, but in PostgreSQL there is one more
> structural level, a database contains schemas, and a schema contains
> tables. I was not aware of this.
>
> Dashamir
>
> _______________________________________________
> Evergreen-general mailing list
> Evergreen-general at list.evergreen-ils.org
> http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-general
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://list.evergreen-ils.org/pipermail/evergreen-general/attachments/20241110/0c56949e/attachment.htm>
More information about the Evergreen-general
mailing list