in command line: psql template1 pgsql -l in PSQL: foodb=#> select datname from pg_database;
- Arash >>> Achilleus Mantzios <[EMAIL PROTECTED]> 11/2/2004 10:21:06 AM >>> O lorid ****** **** Nov 2, 2004 : > \z will list the tables in the dbase > \d tablename will list the columns in the table > or foodb=# SELECT oid,* from pg_database ; > --------------------- > Erik Wasser wrote: > > >Hi list, > > > >how can I list the databases in a postgresish way? I know about the '-l' > >switch of 'psql' but is there a DBI/SQL-query way? I don't want to call > >an external program only to list the databases. I've googled about this > >problem but I only found the '-l'-way to this this. > > > >Ideas? Solutions? > > > > > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faqs/FAQ.html > -- -Achilleus ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
