Reading table name from PgStream

[linux-root]

I'm migrating my application from MariaDB to PostgreSQL. The MariaDB JDBC driver prepends table name to the column name to form column label in result set. Unfortunately, that's not PostgreSQL JDBC behavior. I decided to port the same feature from MariaDB driver to PostgreSQL driver. However, I could not find the way to read the table name associated to each Field. The only information about the table corresponding to a Field is tableOid. Here is the code reading Fields from PgStream in QueryExecutorImpl.java :

       this.pgStream.receiveInteger4();
        int size = this.pgStream.receiveInteger2();
        Field[] fields = new Field[size];
        if (LOGGER.isLoggable(Level.FINEST)) {
            LOGGER.log(Level.FINEST, " <=BE RowDescription({0})", size);
        }

        for(int i = 0; i < fields.length; ++i) {
            String columnLabel = this.pgStream.receiveCanonicalString();
            int tableOid = this.pgStream.receiveInteger4();
            short positionInTable = (short)this.pgStream.receiveInteger2();
            int typeOid = this.pgStream.receiveInteger4();
            int typeLength = this.pgStream.receiveInteger2();
            int typeModifier = this.pgStream.receiveInteger4();
            int formatType = this.pgStream.receiveInteger2();
            fields[i] = new Field(columnLabel, typeOid, typeLength, typeModifier, tableOid, positionInTable);
            fields[i].setFormat(formatType);
            LOGGER.log(Level.FINEST, "        {0}", fields[i]);
        }

My question : Is there any way to obtain table name from PgStream so that I can prepend it to columLabel ? (MariaDB implementation uses its PacketInputStream and can be able to parse table name from it)
Thank you for reading !

[davecramer]

not that I am aware of.

[linux-root]

Thanks!

[vlsi]

Have you checked https://docs.oracle.com/javase/8/docs/api/java/sql/ResultSetMetaData.html#getTableName-int- ?

[linux-root]

Hi @vlsi
Thanks for replying. I tried to read data from ResultSetMetaData but it seems not efficient because the process of obtaining ResultSetMetaData also need to execute queries and parse table information from another ResultSet recursively. So that I got StackOverFlow. My modification affects all the scopes having ResultSet, including the ResultSet for the ResultSetMetaData