I want a postgres function to generate ctid where condition for table migration based ctid

From: "yanliang lei" <msdnchina(at)163(dot)com>
To: "pgsql-docs(at)lists(dot)postgresql(dot)org" <pgsql-docs(at)lists(dot)postgresql(dot)org>
Subject: I want a postgres function to generate ctid where condition for table migration based ctid
Date: 2025-08-01 03:49:03
Message-ID: 143f1cb4.3c39.19863bf61c3.Coremail.msdnchina@163.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-docs

for instance,
select * from tabxxx where ctid >= '(0,0)' AND ctid <= '(27,0)'
select * from tabxxx where ctid > '(27,0)' AND ctid <= '(57,0)'
select * from tabxxx where ctid > '(57,0)' AND ctid <= '(69,0)'

and so on

I want to generate a table ‘s ctid condition automatically

Browse pgsql-docs by date

  From Date Subject
Next Message Fujii Masao 2025-08-03 01:32:17 Make pgoutput documentation easier to find
Previous Message David G. Johnston 2025-07-31 23:39:08 Re: Lets prohibit predicting the future in the documentation.