@@raghuldrag I have customers -schema and having 5 tables with 5000 records for each table. Now I want to take customers schema with only 100 records from each table.
@@mastimasti3898 you can do it but you should create one more table like create table sports as select * from sports_org where sports_name='cricket'; then do pgdump backup
How to take backup with 100 rows from each table?
Can you pls elaborate your questions
@@raghuldrag I have customers -schema and having 5 tables with 5000 records for each table. Now I want to take customers schema with only 100 records from each table.
@@raghuldrag Table is having 1000 records but I want take backup only 200 records using pg_dump. Is it possible? Tell me how ?
@@mastimasti3898 you can do it but you should create one more table like create table sports as select * from sports_org where sports_name='cricket'; then do pgdump backup