Use: select datname from pg_database; =============== Mihir & Biren Partners Majolee InfoTech =============== ----- Original Message ----- From: "Wim Paulussen" <wim@xxxxxxx> To: <pgsql-php@xxxxxxxxxxxxxx> Sent: Monday, March 01, 2004 4:30 PM Subject: [PHP] get list of databases and tables in Postgres > LS, > > Hope you can help : I am looking for equivalent sql statement for the > following in MySQL : > SHOW DATABASES > > I found out that for the tables you can connect to a Postgresql specific > table information_schema.tables , but what is the corresponding table > for the names of databases under Postgresql ? > > All help is highly appreciated. > > > > ---------------------------(end of broadcast)--------------------------- > TIP 9: the planner will ignore your desire to choose an index scan if your > joining column's datatypes do not match > >
