From: | Juan Carlos Rodríguez Sulca <jrodriguez(at)minag(dot)gob(dot)pe> |
---|---|
To: | <pgsql-ayuda(at)tlali(dot)iztacala(dot)unam(dot)mx> |
Subject: | [Pgsql-ayuda] RE: Pgsql-ayuda digest, Vol 1 #313 - 2 msgs |
Date: | 2002-10-09 15:24:51 |
Message-ID: | 001001c26fa8$036d9fa0$e201010a@wsaudint01 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-es-ayuda |
Amigos de la lista, un amigo me indico que hay una versión de Postgres para
Windows, donde podría bajarlo.
Gracias,
Juan Carlos Rodríguez Sulca
Analista de Sistemas
Ministerio de Agricultura
E-Mail : jrodriguez(at)minag(dot)gob(dot)pe
Telefono: (051) 01 431-0265
TeleFax : (051) 01 433-3034 Anx. 2236
-----Mensaje original-----
De: pgsql-ayuda-admin(at)tlali(dot)iztacala(dot)unam(dot)mx
[mailto:pgsql-ayuda-admin(at)tlali(dot)iztacala(dot)unam(dot)mx]En nombre de
pgsql-ayuda-request(at)tlali(dot)iztacala(dot)unam(dot)mx
Enviado el: sábado, 05 de octubre de 2002 8:37
Para: pgsql-ayuda(at)tlali(dot)iztacala(dot)unam(dot)mx
Asunto: Pgsql-ayuda digest, Vol 1 #313 - 2 msgs
Send Pgsql-ayuda mailing list submissions to
pgsql-ayuda(at)tlali(dot)iztacala(dot)unam(dot)mx
To subscribe or unsubscribe via the World Wide Web, visit
http://tlali.iztacala.unam.mx/mailman/listinfo/pgsql-ayuda
or, via email, send a message with subject or body 'help' to
pgsql-ayuda-request(at)tlali(dot)iztacala(dot)unam(dot)mx
You can reach the person managing the list at
pgsql-ayuda-admin(at)tlali(dot)iztacala(dot)unam(dot)mx
When replying, please edit your Subject line so it is more specific
than "Re: Contents of Pgsql-ayuda digest..."
Today's Topics:
1. Listado de tablas (AAAGU)
2. Re: Listado de tablas (Ing. Roberto Andrade Fonseca)
--__--__--
Message: 1
Date: Fri, 4 Oct 2002 12:17:03 -0700 (PDT)
From: AAAGU <gustra76(at)yahoo(dot)com>
To: pgsql-ayuda(at)tlali(dot)iztacala(dot)unam(dot)mx
Subject: [Pgsql-ayuda] Listado de tablas
Holas,
soy nuevo en esto. Alguien podria decirme si es
posible obtener un listado con los campos de
determinada tabla si, por ejemplo, estoy trabajando
con Java y Postgresql?
Gracias.
__________________________________________________
Do you Yahoo!?
New DSL Internet Access from SBC & Yahoo!
http://sbc.yahoo.com
--__--__--
Message: 2
Date: Fri, 4 Oct 2002 15:50:29 -0500 (CDT)
From: "Ing. Roberto Andrade Fonseca" <randrade(at)abl(dot)com(dot)mx>
To: AAAGU <gustra76(at)yahoo(dot)com>
Cc: pgsql-ayuda(at)tlali(dot)iztacala(dot)unam(dot)mx
Subject: Re: [Pgsql-ayuda] Listado de tablas
Hola:
On Fri, 4 Oct 2002, AAAGU wrote:
> Holas,
> soy nuevo en esto. Alguien podria decirme si es
> posible obtener un listado con los campos de
> determinada tabla si, por ejemplo, estoy trabajando
> con Java y Postgresql?
> Gracias.
Si ejecutas psql con el par=E1metro -E puedes ver las consultas que genear =
los comandos internos, entre ellos el comando \d:
Por ejemplo:
\d pais
genera:
********* QUERY **********
SELECT relhasindex, relkind, relchecks, reltriggers, relhasrules
FROM pg_class WHERE relname=3D'pais'
**************************
********* QUERY **********
SELECT a.attname, format_type(a.atttypid, a.atttypmod), a.attnotnull, a.att=
hasdef, a.attnum
FROM pg_class c, pg_attribute a
WHERE c.relname =3D 'pais'
AND a.attnum > 0 AND a.attrelid =3D c.oid
ORDER BY a.attnum
**************************
********* QUERY **********
SELECT substring(d.adsrc for 128) FROM pg_attrdef d, pg_class c
WHERE c.relname =3D 'pais' AND c.oid =3D d.adrelid AND d.adnum =3D 1
**************************
********* QUERY **********
SELECT c2.relname
FROM pg_class c, pg_class c2, pg_index i
WHERE c.relname =3D 'pais' AND c.oid =3D i.indrelid AND i.indexrelid =3D c2=
=2Eoid
AND NOT i.indisunique ORDER BY c2.relname
**************************
********* QUERY **********
SELECT c2.relname
FROM pg_class c, pg_class c2, pg_index i
WHERE c.relname =3D 'pais' AND c.oid =3D i.indrelid AND i.indexrelid =3D c2=
=2Eoid
AND i.indisprimary AND i.indisunique ORDER BY c2.relname
**************************
********* QUERY **********
SELECT c2.relname
FROM pg_class c, pg_class c2, pg_index i
WHERE c.relname =3D 'pais' AND c.oid =3D i.indrelid AND i.indexrelid =3D c2=
=2Eoid
AND NOT i.indisprimary AND i.indisunique ORDER BY c2.relname
**************************
********* QUERY **********
SELECT t.tgname
FROM pg_trigger t, pg_class c
WHERE c.relname=3D'pais' AND c.oid =3D t.tgrelid
**************************
Table "pais"
Column | Type | Modifiers =
=20
-------------+-----------------------+-------------------------------------=
------------
id | integer | not null default nextval('"pais_id_s=
eq"'::text)
descripcion | character varying(30) |=20
Primary key: pais_pkey
Triggers: RI_ConstraintTrigger_153561,
RI_ConstraintTrigger_153563
La que necesitas es:
SELECT a.attname, format_type(a.atttypid, a.atttypmod), a.attnotnull, a.att=
hasdef, a.attnum
FROM pg_class c, pg_attribute a
WHERE c.relname =3D 'pais'
AND a.attnum > 0 AND a.attrelid =3D c.oid
ORDER BY a.attnum
pero tal ves debes pedir menos campos.
Saludos,
Roberto Andrade Fonseca
randrade(at)abl(dot)com(dot)mx
--__--__--
_______________________________________________
Pgsql-ayuda mailing list
Pgsql-ayuda(at)tlali(dot)iztacala(dot)unam(dot)mx
http://tlali.iztacala.unam.mx/mailman/listinfo/pgsql-ayuda
End of Pgsql-ayuda Digest
From | Date | Subject | |
---|---|---|---|
Next Message | Julio Alberto Carrillo Martinez | 2002-10-09 17:19:34 | [Pgsql-ayuda] Indices y Consultas |
Previous Message | aurygp | 2002-10-09 07:25:54 | [Pgsql-ayuda] tamanho de una bd... |