Query to check Progress of Alter Statements PostgreSQL

From: Raj kumar <rajkumar820999(at)gmail(dot)com>
To: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Query to check Progress of Alter Statements PostgreSQL
Date: 2022-07-22 09:11:25
Message-ID: CACxU--Uso3-GbyNXM8aEHL-yFK2MhBBa+p3Fbs24D-MnEAnkpQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

Is there a system table to query the progress of Alter Statements like Type
Modification and Key Creation in PostgreSQL?

1. alter table seqentry1 alter column "timestamp" type text USING
"timestamp"::text;
2. ALTER TABLE ONLY public.seqentry2 ADD CONSTRAINT fk_seq2 FOREIGN KEY
(seq_id) REFERENCES public.seqshow(seq_id);

Thanks,
Raj Kumar

Browse pgsql-admin by date

  From Date Subject
Next Message Murthy Nunna 2022-07-22 16:19:42 pg_upgrade failure upgrading from v10.8 to v14.4
Previous Message pig lee 2022-07-21 07:23:24 Re: About limitation of using postgresql in china