Hi, guys,
On Tue, Jul 19, 2022 at 4:42 AM Walter Dörwald wrote:
>
> On 19 Jul 2022, at 5:10, Igor Korot wrote:
>
> Hi, guys,
>
> In the database theory each table is identified as "schema_name"."table_name".
>
> When I tried to look at how to get the table id inside the PostgreSQL,
> I saw that I
On 19 Jul 2022, at 5:10, Igor Korot wrote:
Hi, guys,
In the database theory each table is identified as
"schema_name"."table_name".
When I tried to look at how to get the table id inside the PostgreSQL,
I saw that I needed to look at the pg_class table.
SELECT oid FROM pg_class WHERE relnam
On Mon, Jul 18, 2022 at 8:11 PM Igor Korot wrote:
>
> There is a pg_namespace table - is this where the schema should come from?
> If yes - how?
> Looking at that table I don't see any unique fields...
> Or is this something that is hidden?
>
Catalogs don't have all of the same metadata that use
