postgres equivalent's

Nick Estes plug-discuss@lists.plug.phoenix.az.us
Sat, 14 Jun 2003 10:07:31 -0700 (MST)


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

> mysqlshow

If you tell me what it does, I'm sure I could tell you the equivalent (-=


> mysqladmin create <db>

createdb <db>

Simlar programs that come in handy are: dropdb, createuser, and
vacuumdb


> show tables;

\dt

See also: \d to show everything (tables, sequences, etc), there's also a
few others to show other info.


> describe <table>;

\d <table>

	--Nick

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.2 (GNU/Linux)
Comment: pgpenvelope 2.10.2 - http://pgpenvelope.sourceforge.net/

iD8DBQE+61ZXv+hjYTGg7s4RAp7mAJ92Aknx7/OnJ3tgTJXXrjm2BrXWpQCeNzaz
SQnuNVanHpkPMEOtsY5Lots=
=SN5G
-----END PGP SIGNATURE-----