[Pgsql-ayuda] listar tablas de un bd
sandrigo lezcano
psql@msa.com.py
Mon, 19 May 2003 16:04:57 -0500
This is a multi-part message in MIME format.
------=_NextPart_000_01D9_01C31E20.6501A820
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
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)
dbtest1=3D#
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_01D9_01C31E20.6501A820
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=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 =
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=
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></BODY></HTML>
------=_NextPart_000_01D9_01C31E20.6501A820--