Good Morning,
We have a table - I'll call it *import_job* (which is the actual name) -
that lists jobs to be executed. Each job has one or more child components
listed in another table called *import_file*.
The child table has a foreign key column called *import_job_oid*
referencing the primary
into the partitioned table.
Dropped the original table and renamed the partitioned table.
Easy, no problems. Also no 'attach'.
Thanks.
On Fri, Jun 7, 2024 at 3:31 AM Laurenz Albe
wrote:
> On Thu, 2024-06-06 at 11:28 -0500, David Barbour wrote:
> > Been an Oracle DBA for
Hi,
New to this list and to Postgres. Been an Oracle DBA for quite a while and
we're moving from Oracle to Postgres.
I have a table that I need to transform into a hash partitioned table.
I've gone through all the steps to create a hash partitioned table, with 8
partitions such as
create table