Re: [SQL] pg_dump using SQL

2008-03-19 Thread Preston Landers
Yusnel Rojas Garc?a([EMAIL PROTECTED])@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 alway

Re: [SQL] pg_dump using SQL

2008-03-18 Thread Tom Lane
"Phillip Smith" <[EMAIL PROTECTED]> writes: >> Is there any way to do what pg_dump does?, I mean, get the structure of a >> table in a database (ex: CREATE TABLE ...) > Turn Query Logging on in postgresql.conf then see what queries are executed > by pgAdmin or similar when you run it? But note th

Re: [SQL] pg_dump using SQL

2008-03-18 Thread Phillip Smith
> Is there any way to do what pg_dump does?, I mean, get the structure of a table in a database (ex: CREATE TABLE ...) Turn Query Logging on in postgresql.conf then see what queries are executed by pgAdmin or similar when you run it? THINK BEFORE YOU PRINT - Save paper if you don't really need t

[SQL] pg_dump using SQL

2008-03-18 Thread Yusnel Rojas GarcĂ­a
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 ...) thanks in advance.