Re: pg_dump using SQL - Mailing list pgsql-sql

From Preston Landers
Subject Re: pg_dump using SQL
Date
Msg-id 20080319202412.GJ25994@journyx.com
Whole thread Raw
In response to pg_dump using SQL  ("Yusnel Rojas García" <onemoverx@gmail.com>)
List pgsql-sql
Yusnel Rojas Garc?a(onemoverx@gmail.com)@2008.03.18 11:45:03 -0800:
> Hi everyone
> 
> Is there any way to do what pg_dump does?, I mean, get the structure of a
> table in a database (ex: CREATE TABLE ...)
> 

If you want to programmaticly discover the elements in a database
schema then you can always query the INFORMATION_SCHEMA:

http://www.postgresql.org/docs/current/static/information-schema.html

That isn't the same as having the raw DLL statements that created
them, but depending on your purpose may be good enough.

regards,
Preston


pgsql-sql by date:

Previous
From: "Rodrigo E. De León Plicet"
Date:
Subject: Re: Date and filling issues
Next
From: Gavin 'Beau' Baumanis
Date:
Subject: Select into