How to get the postgresql column names in java springboot

Question

I'm trying to get the postgresql table column name. I've tried using information_schema but it doesn't work on my java mvc project. What should I do ?

This is actually my first question on StackOverflow, so I'm sorry if my question is difficult to understand. Thank you!

public interface MyFileRepository extends JpaRepository<MyEntityModel, Long> {
    @Query("select column_name,data_type from information_schema.columns where table_name = 'MyEntityModel';")
    List<MyEntityModel> myList();
}

You could have a look at the link here https://stackoverflow.com/q/36328063/5891534 — Sneharghya Pathak, May 15 '20 at 04:42

score 0 · Answer 1 · answered May 15 '20 at 05:13

About schema. You can set default schema by two ways:

Put it to the properties(or .yml file) spring.datasource.schema = #your schema name
Put it in your entity model @Table(schema = "SCHEMA_NAME")

About getting information about table you can look this one open question:

Is there any Simplest way to get Table metadata (column name list) information, in Spring Data JPA ? which could I use on universal database

How to get the postgresql column names in java springboot

1 Answers1