psql

\l => list database
\c <db name>: connect to a certain database
\dt: list all tables in the current database using your search_path
\dt *.: list all tables in the current database regardless your search_path
SELECT * FROM osm_poi_point LIMIT 1

SELECT name,name_en,subclass,mapping_key,osm_id,geometry FROM osm_poi_point WHERE name <> '' LIMIT 1;

Révision #2
Créé 2023-03-22 22:36:25 UTC par tjiho
Mis à jour 2023-10-08 18:02:28 UTC par tjiho