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
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
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
