# 260324-Inventaire des tables de données dans public du POSTGIS

**docker exec -it alteris\_postgis psql -U alteris\_admin -d alteris\_geo -c "\\dt"**

debian@vps-02c1f983-vps-ovh-net:~$ docker exec -it alteris\_postgis psql -U alteris\_admin -d alteris\_geo -c "\\dt"  
 List of relations

  
 Schema | Name | Type | Owner  
\----------+--------------------------------+-------+---------------  
 public | artificialisation\_13028 | table | alteris\_admin  
 public | baac\_nat\_2018 | table | alteris\_admin  
 public | baac\_nat\_2019 | table | alteris\_admin  
 public | baac\_nat\_2020 | table | alteris\_admin  
 public | baac\_nat\_2021 | table | alteris\_admin  
 public | baac\_nat\_2022 | table | alteris\_admin  
 public | baac\_nat\_2023 | table | alteris\_admin  
 public | baac\_paca\_2024 | table | alteris\_admin  
 public | buildings | table | alteris\_admin  
 public | carroye\_13028 | table | alteris\_admin  
 public | centralites\_polygones\_13028 | table | alteris\_admin  
 public | communes\_paca | table | alteris\_admin  
 public | election\_paca\_communes | table | alteris\_admin  
 public | elections\_paca | table | alteris\_admin  
 public | elections\_paca\_muni\_26 | table | alteris\_admin  
 public | hierarchie\_fonctionnelle\_13028 | table | alteris\_admin  
 public | i\_t1\_03 | table | alteris\_admin  
 public | indicateur\_i\_t1\_02\_final | table | alteris\_admin  
 public | indicateurs\_crise\_de\_confiance | table | alteris\_admin  
 public | landuse | table | alteris\_admin  
 public | natural | table | alteris\_admin  
 public | natural\_points | table | alteris\_admin  
 public | occsol\_complet\_13028 | table | alteris\_admin  
 public | places | table | alteris\_admin  
 public | places\_points | table | alteris\_admin  
 public | plu\_13028 | table | alteris\_admin  
 public | pofw | table | alteris\_admin  
 public | pofw\_points | table | alteris\_admin  
 public | pois | table | alteris\_admin  
 public | pois\_13028 | table | alteris\_admin  
 public | pois\_points | table | alteris\_admin  
 public | railways | table | alteris\_admin  
 public | roads | table | alteris\_admin  
 public | roads\_13028 | table | alteris\_admin  
 public | sirene\_paca\_brut | table | alteris\_admin  
 public | spatial\_ref\_sys | table | alteris\_admin  
 public | trafic | table | alteris\_admin  
 public | trafic\_points | table | alteris\_admin  
 public | transport | table | alteris\_admin  
 public | transport\_points | table | alteris\_admin  
 public | vacc\_grippe\_brut | table | alteris\_admin  
 public | vacc\_rougeole\_brut | table | alteris\_admin  
 public | water | table | alteris\_admin  
 public | waterways | table | alteris\_admin  
 public | zones\_motifs\_filaires\_13028 | table | alteris\_admin  
\--More--