@harshtech123 , are you collaborating with @asr2003 on #162? There seems to be very similar implementation on both of these PRs.

@ChuckHend no i created a pr before he did and i have no idea about what he was doing ...

@ChuckHend i just wants a neat and clean pr thats why i created a new one , before this i made changes on #161

Maybe I am using the function wrong?

postgres=# select vectorize.chunk_table('products', 'description', 2);
ERROR:  column "id" does not exist
LINE 1: SELECT id, description FROM products
               ^
QUERY:  SELECT id, description FROM products

• @ChuckHend function can be called using SELECT vectorize.chunk_table('input_table', 'column_name', 1000, 'output_table');
• i am making this as standalone and adding test in meaninwhile time

@ChuckHend the function is ready to test
1 install every necessary extension and started psql
2 created a table using -

CREATE TABLE products (
    id SERIAL PRIMARY KEY,
    description TEXT
);

3 insert data to test on - INSERT INTO products (description) VALUES ('This is a test string that will be chunked into smaller pieces.');
4 run the chunk_tabel function - SELECT vectorize.chunk_table('products', 'description', 10, 'chunked_data');
5 finally verify the chunk data - SELECT * FROM chunked_data;

/split @asr2003