Re: how to recall the initial definition (CREATE TABLE)

From: Sean Davis <sdavis2(at)mail(dot)nih(dot)gov>
To: Joao Miguel Ferreira <jmf(at)estg(dot)ipvc(dot)pt>, <pgsql-novice(at)postgresql(dot)org>
Subject: Re: how to recall the initial definition (CREATE TABLE)
Date: 2006-01-09 14:08:53
Message-ID: BFE7D8A5.3499%sdavis2@mail.nih.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On 1/9/06 1:27 PM, "Joao Miguel Ferreira" <jmf(at)estg(dot)ipvc(dot)pt> wrote:

> Hello all at PG,
>
> Let's say I forgot the "definition" of a table (.. the original CREATE
> TABLE query)...

Use pg_dump or use some program like PgAdminIII to give you the table
definition. There is no "DESCRIBE mytable" like in MySQL.

Sean

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Brad Nicholson 2006-01-09 15:35:08 Re: how to list all tables in a database
Previous Message A. Kretschmer 2006-01-09 14:08:15 Re: how to recall the initial definition (CREATE TABLE) of a table ?