[Pgsql-ayuda] listar tablas de un bd
Jorge Zurita
jorgeze@tutopia.com
Thu, 22 May 2003 18:30:59 -0500
This is a multi-part message in MIME format.
------=_NextPart_000_0101_01C32090.4AD5A240
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
=20
dbtest1=3D#\d
----- Original Message -----=20
From: sandrigo lezcano=20
To: Pgsql-ayuda=20
Sent: Monday, May 19, 2003 4:04 PM
Subject: [Pgsql-ayuda] listar tablas de un bd
algun comando especifico q me permitar ver la lista de tablas dentro =
de una bd.
tipo:
dbtest1=3D#\l
List of databases
Database | Owner | Encoding=20
----------+----------+---------
dbtest1 | postgres |SQL_ASCII
template0 | postgres |SQL_ASCII
template0 | postgres |SQL_ASCII
(3 rows)
=20
dbtest1=3D#
=20
=20
pero si quiero las tablas de dbtest1....???
pues en el cliente con el PowerBuilder no hay problemas pero... y en =
el psql=3D=3D
gracias
____________________________________________________
Sandrigo Lezcano Jara Asunci=F3n, Paraguay
usando______: Ret Hat 7.2 (Enigma) - Kernel 2.4.7-10=20
PostgreSQL 7.1.3 - psqlODBC 7.02.00.01
migrando____: Sybase 6.5 al PostgreSQL=20
front end___: PowerBuilder 6.5 =20
=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3DICQ:143590717=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
____________________________________________________
------=_NextPart_000_0101_01C32090.4AD5A240
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2614.3500" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2><FONT face=3DArial size=3D2>
<DIV><FONT face=3DCourier size=3D2>dbtest1=3D#\d</FONT></DIV>
<DIV> </DIV></FONT></FONT>
<DIV> </DIV>
<DIV>----- Original Message ----- </DIV></DIV>
<BLOCKQUOTE=20
style=3D"BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: =
0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">
<DIV=20
style=3D"BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: =
black"><B>From:</B>=20
<A href=3D"mailto:psql@msa.com.py" title=3Dpsql@msa.com.py>sandrigo =
lezcano</A>=20
</DIV>
<DIV style=3D"FONT: 10pt arial"><B>To:</B> <A=20
href=3D"mailto:Pgsql-ayuda@tlali.iztacala.unam.mx"=20
title=3DPgsql-ayuda@tlali.iztacala.unam.mx>Pgsql-ayuda</A> </DIV>
<DIV style=3D"FONT: 10pt arial"><B>Sent:</B> Monday, May 19, 2003 4:04 =
PM</DIV>
<DIV style=3D"FONT: 10pt arial"><B>Subject:</B> [Pgsql-ayuda] listar =
tablas de=20
un bd</DIV>
<DIV><BR></DIV>
<DIV><FONT face=3DCourier size=3D2>algun comando especifico q me =
permitar ver la=20
lista de tablas dentro de una bd.</FONT></DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV><FONT face=3DCourier size=3D2>tipo:</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DCourier size=3D2>dbtest1=3D#\l</FONT></DIV>
<DIV><FONT face=3DCourier size=3D2> List of=20
databases</FONT></DIV>
<DIV><FONT face=3DCourier size=3D2>Database | =
Owner |=20
Encoding </FONT></DIV>
<DIV><FONT face=3DCourier =
size=3D2>----------+----------+---------</FONT></DIV>
<DIV><FONT face=3DCourier size=3D2>dbtest1 | postgres=20
|SQL_ASCII</FONT></DIV>
<DIV><FONT face=3DCourier size=3D2>template0 | postgres =
|SQL_ASCII</FONT></DIV>
<DIV><FONT face=3DCourier size=3D2>
<DIV><FONT face=3DCourier size=3D2>template0 | postgres =
|SQL_ASCII</FONT></DIV>
<DIV>(3 rows)</DIV>
<DIV>
<DIV><FONT face=3DCourier size=3D2></FONT> </DIV>
<DIV><FONT face=3DCourier =
size=3D2>dbtest1=3D#</FONT></DIV></DIV></FONT></DIV>
<DIV><FONT face=3DCourier size=3D2></FONT> </DIV>
<DIV><FONT face=3DCourier size=3D2></FONT> </DIV>
<DIV><FONT face=3DCourier size=3D2>pero si quiero las tablas de=20
dbtest1....???</FONT></DIV>
<DIV><FONT face=3DCourier size=3D2>pues en el cliente con el =
PowerBuilder no hay=20
problemas pero... y en el psql=3D=3D</FONT></DIV>
<DIV><FONT face=3DCourier size=3D2>gracias</FONT></DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV><FONT face=3DCourier=20
=
size=3D2>____________________________________________________<BR>Sandrigo=
=20
Lezcano=20
=
Jara &nb=
sp;=20
Asunci=F3n, Paraguay<BR>usando______: Ret Hat 7.2 (Enigma) - Kernel =
2.4.7-10=20
=
<BR> &nb=
sp; =20
PostgreSQL 7.1.3 - psqlODBC 7.02.00.01<BR>migrando____: Sybase =
6.5 =20
al PostgreSQL <BR>front end___: PowerBuilder=20
6.5 =20
=
<BR>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3DICQ:143590717=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D<BR>_________=
___________________________________________</FONT></DIV></BLOCKQUOTE></BO=
DY></HTML>
------=_NextPart_000_0101_01C32090.4AD5A240--