;
> 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
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
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
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