Michael Dengler wrote: > Hi, > > Is there a query I can perform (perhaps on a system table) to return all > of the column names (ONLY the column names) for a given DB? (I seem to > remember doing this before but cant remember how) > > Thanks > > Mike >
The 'columns' view in information_schema should do the trick for you. -Jon -- Senior Systems Developer Media Matters for America http://mediamatters.org/ ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate
