Thread

1. SHOW , DESCRIBE, oh what's it called...

   Paul Fontenot <paul@code-slinger.com> — 2000-06-13T23:22:16Z

   In MySQL you could issue a command:
   
   describe my_table_name;
   
   and it would come back with the columns, and their descriptions. What is the
   equivalent command in postgresql? I have looked everywhere and am probly
   just overlooking it by now.
   
   Thanks,
   	Paul
   
   
   

2. Re: SHOW , DESCRIBE, oh what's it called...

   D. Duccini <duccini@backpack.com> — 2000-06-13T23:25:37Z

   \d tablename
   
   On Tue, 13 Jun 2000, Paul Fontenot wrote:
   
   > In MySQL you could issue a command:
   > 
   > describe my_table_name;
   > 
   > and it would come back with the columns, and their descriptions. What is the
   > equivalent command in postgresql? I have looked everywhere and am probly
   > just overlooking it by now.
   > 
   > Thanks,
   > 	Paul
   > 
   
   
   -----------------------------------------------------------------------------
   david@backpack.com            BackPack Software, Inc.        www.backpack.com
   +1 651.645.7550 voice       "Life is an Adventure.    
   +1 651.645.9798 fax            Don't forget your BackPack!"   
   -----------------------------------------------------------------------------
   
   
   

3. Re: SHOW , DESCRIBE, oh what's it called...

   Anthony E . Greene <agreene@pobox.com> — 2000-06-14T12:02:25Z

   At 16:22 2000-06-13 -0700, Paul Fontenot wrote:
   >In MySQL you could issue a command:
   >
   >describe my_table_name;
   >
   >and it would come back with the columns, and their descriptions. What is the
   >equivalent command in postgresql? I have looked everywhere and am probly
   >just overlooking it by now.
   
   pg_dump -s dbname > dbname.schema
   
   
    Tony
    --
    Anthony E. Greene <agreene@pobox.com>
    PGP Key: 0x6C94239D/7B3D BD7D 7D91 1B44 BA26  C484 A42A 60DD 6C94 239D
    Linux: The choice of a GNU Generation.
   
   

4. Re: SHOW , DESCRIBE, oh what's it called...

   Karl F. Larsen <k5di@zianet.com> — 2000-06-15T12:05:24Z

   In psql you show all tables with \d and you display a tables content with
   the SQL call: SELECT * from <table name>;
   
   On Tue, 13 Jun 2000, Paul Fontenot wrote:
   
   > In MySQL you could issue a command:
   > 
   > describe my_table_name;
   > 
   > and it would come back with the columns, and their descriptions. What is the
   > equivalent command in postgresql? I have looked everywhere and am probly
   > just overlooking it by now.
   > 
   > Thanks,
   > 	Paul
   > 
   > 
   > 
   
   Yours Truly,
   
     	 - Karl F. Larsen, k5di@arrl.net  (505) 524-3303  -