am 16.02.2006, um 14:43:43 +0530 mailte AKHILESH GUPTA folgendes: > hi all, > i just want to know one thing that is there any function in PGSQL which > gives me the total number of columns in a table.
select count(column_name) from information_schema.columns where table_name='foo'; HTH, Andreas -- Andreas Kretschmer (Kontakt: siehe Header) Heynitz: 035242/47215, D1: 0160/7141639 GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net === Schollglas Unternehmensgruppe === ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq