Skip site navigation (1) Skip section navigation (2)

Re: pg_dump using SQL

From: Preston Landers <planders(at)journyx(dot)com>
To: Yusnel Rojas Garc?a <onemoverx(at)gmail(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: pg_dump using SQL
Date: 2008-03-19 20:24:12
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-sql
Yusnel Rojas Garc?a(onemoverx(at)gmail(dot)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:

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


In response to

pgsql-sql by date

Next:From: Dean Gibson (DB Administrator)Date: 2008-03-19 22:00:31
Subject: Re: compare 2 tables in sql
Previous:From: Volkan YAZICIDate: 2008-03-19 19:09:34
Subject: Re: compare 2 tables in sql

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group