Is there a way to check the partition column on a table in Postgres v16+
I have been trying to find a way to get this from a sql script to no avail. I have been looking at the schema information tables but I just can’t find anything that would tell me if a table has this PARTITION BY, or rather, it was created with it, as it is my understanding currently the ALTER TABLE … PARTITION BY… is not an option.
Is there a way to check the partition column on a table in Postgres v16+
I have been trying to find a way to get this from a sql script to no avail. I have been looking at the schema information tables but I just can’t find anything that would tell me if a table has this PARTITION BY, or rather, it was created with it, as it is my understanding currently the ALTER TABLE … PARTITION BY… is not an option.
Hardware Configuration for PostgreSQL on OLTP environment
Please suggest me for the below points.
pgadmin4 error when restoring database from tar file (PostgreSQL 16)
Screenshot of what pgadmin shows me
I´m trying to load a tar file usinf pgAdmin 4 (PostgreSQL16) on my Mac, but it´s failing and all I get is “Process failed” as shown on the screenshot, but doesn´t show me what kind of error might be! I´m not sure what to do and the information I hace found on internet is not helping me! Does anyone has an idea what to do?
Not able to run a trigger on Foreign Table to update local table using postgres_fdw
I’ve tried several variation and looked at examples of existing threads related to running triggers on foreign table and none have worked so far. The postgres_fdw documentation suggests setting the SHEMA path, which I’ve done (although I’m not sure if this is correct).