what is partition_position in all_tab_partitions
Anyone can Explain what is partition_position in all_tab_partitions.
And anyone can tell me what is conversion of this
SELECT partition_position
FROM all_tab_partitions tp
WHERE tp.table_owner = ? AND
tp.table_name = ? AND
tp.partition_name = ?
to Postgres.
Solution 1:
ALL_TAB_PARTITIONS
| Column | Datatype | Description |
|---|---|---|
| PARTITION_POSITION | NUMBER | Position of the partition within the table |
I don't know how (if anyhow) it can be translated from Oracle to PostgreSQL.