$ psqldef --version
3.9.5 (cbca1fd)

$ psql -h localhost -U postgres
postgres=# create schema my_schema;
CREATE SCHEMA

$ cat test.sql
-- comment
create table my_schema.foo (id int);
create index idx_foo_id on my_schema.foo (id);

$ export PSQLDEF_PARSER=pgquery
$ cat test.sql | psqldef  -h localhost -U postgres postgres
-- Apply --
BEGIN;
-- comment
create table my_schema.foo (id int);
create index idx_foo_id on my_schema.foo (id);
ROLLBACK;
2026/02/03 17:47:02 pq: relation "my_schema.foo" does not exist (42P01)