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