newbie question
I'm new with postgresql. How can i show table name and db name in
postgresql like SHOW TABLE and SHOW DATABASE in MySQL.
Thanks
Said Badrul Nahar
I'm new with postgresql. How can i show table name and db name in
postgresql like SHOW TABLE and SHOW DATABASE in MySQL.
The equivalent of SHOW TABLE foo; in pg would be:
\d foo
Note that there is no ; at the end of that command.
I'm not sure what's equivalent to SHOW DATABASE.
just \d
...
On 5 Nov 2001 00:43:45 -0000, "Dr. Evil" <drevil@sidereal.kz> wrote:
The equivalent of SHOW TABLE foo; in pg would be:
\d foo
Note that there is no ; at the end of that command.
I'm not sure what's equivalent to SHOW DATABASE.
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
Aasmund Midttun Godal
aasmund@godal.com - http://www.godal.com/
+47 40 45 20 46
Import Notes
Reply to msg id not found: 20011105004345.6916.qmail@sidereal.kzfromDr.Evilon5Nov2001004345-0000
I'm new with postgresql. How can i show table name and db name in
postgresql like SHOW TABLE and SHOW DATABASE in MySQL.
In psql:
\d
\l
\?
to show:
tables
databases
other backslash commands
erm, sorry, if you wanna see all the databases you can always:
SELECT datname FROM pg_database;
On Mon, 05 Nov 2001 01:27:29 GMT, "Aasmund Midttun Godal" <postgresql@envisity.com> wrote:
just \d
...
On 5 Nov 2001 00:43:45 -0000, "Dr. Evil" <drevil@sidereal.kz> wrote:
Aasmund Midttun Godal
aasmund@godal.com - http://www.godal.com/
+47 40 45 20 46---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
Aasmund Midttun Godal
aasmund@godal.com - http://www.godal.com/
+47 40 45 20 46
Import Notes
Reply to msg id not found: 20011105012729.13247.qmail@ns.krot.orgfromAasmundMidttunGodalonMon05Nov2001012729GMT
