Use ctid in spring data JPS repository #postgres #sringdatajpa

NamesToDiff1Repository.java

import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.CrudRepository;

import java.util.Optional;

public interface NamesToDiff1Repository extends CrudRepository<NamesToDiff1, Long> {
    @Query(value = "SELECT ctid FROM names", nativeQuery = true)
    Iterable<Object> findAllRowIds();

    @Query(value = "SELECT * FROM names WHERE ctid = ?::tid", nativeQuery = true)
    Optional<NamesToDiff1> findByCtId(String ctid);
}