demo=# select format('pg_dump --schema-only -t %I -f %I/%I.sql', tablename, schemaname, tablename) as dump from pg_tables where schemaname = 'bookings';
                                   dump                                   
--------------------------------------------------------------------------
 pg_dump --schema-only -t seats -f bookings/seats.sql
 pg_dump --schema-only -t ticket_flights -f bookings/ticket_flights.sql
 pg_dump --schema-only -t flights -f bookings/flights.sql
 pg_dump --schema-only -t airports_data -f bookings/airports_data.sql
 pg_dump --schema-only -t bookings -f bookings/bookings.sql
 pg_dump --schema-only -t boarding_passes -f bookings/boarding_passes.sql
 pg_dump --schema-only -t tickets -f bookings/tickets.sql
 pg_dump --schema-only -t aircrafts_data -f bookings/aircrafts_data.sql