Espero te ayude* SELECT c.column_name AS column_name, c.data_type, c.is_nullable AS nullable FROM information_schema.columns c LEFT JOIN information_schema.element_types e ON c.table_catalog = e.object_catalog AND c.table_schema = e.object_schema AND c.table_name = e.object_name AND ''TABLE'' = e.object_type WHERE UPPER(c.table_name) = upper( 'NOMBRE_TABLA' ) ORDER BY c.ordinal_position*
2009/3/19 Jorge A. Barzola Rosadio <[email protected]> > Hola a todos. mi pregunta es la siguiente, SQL Server usaba este codigo > para obtener las columnas de una tabla: > > SELECT* > FROM syscolumns , sysobjects > WHERE syscolumns.id = sysobjects.id > AND dbo.sysobjects.xtype = 'U' > AND sysobjects.name = 'gen_cliente' > > En PostgreSQL hay algo similar a syscolumns y sysobjects > > Gracias > > -- > Jorge A. Barzola Rosadio > Analista, Desarrollador de Sistemas > > Movil : (511) 980456604 - Claro > Msn : [email protected] > > Lima - Perú > -- Atentamente, ______________________________ ERIK FERNEY CUBILLOS GARCIA Ing. Desarrollo - Kactus HR DIGITAL WARE LTDA. Calle 72 No. 12-65 Piso 2 Bogotá, Colombia [email protected] www.digitalware.com.co
