Re: [GENERAL] How to retrieve table definition in SQL

2000-03-21 Thread Jose Soares
; > Organization: Sfera Carta > Newsgroups: muc.lists.postgres.questions > Date: 20 Mar 2000 17:04:13 +0100 > Subject: Re: [GENERAL] How to retrieve table definition in SQL > > If you start pgsql with -E parameter > when you type \d pgsql shows you the query it executes to display > the table definiti

Re: [GENERAL] How to retrieve table definition in SQL

2000-03-19 Thread Ed Loehr
Stan Jacobs wrote: > > This isn't quite what I'm looking for, though I can't run a script on > that machine, so I need to retrieve it with an SQL query. Ie. "SELECT * > from data_key_table_name_something"... *smile* Judging from the few > responses so far, it doesn't sound like there's an

Re: [GENERAL] How to retrieve table definition in SQL

2000-03-19 Thread Stan Jacobs
This isn't quite what I'm looking for, though I can't run a script on that machine, so I need to retrieve it with an SQL query. Ie. "SELECT * from data_key_table_name_something"... *smile* Judging from the few responses so far, it doesn't sound like there's an easy way to do this. On S

Re: [GENERAL] How to retrieve table definition in SQL

2000-03-19 Thread omid omoomi
Hi, There are some system tables in any pg database which contain information about table/field names/types and descriptions. use -e with psql command, and look at the sql code when running /d commands. regards. Omid Omoomi >From: Stan Jacobs <[EMAIL PROTECTED]> >To: [EMAIL PROTECTED] >Subject