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 always

[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.

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

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 that these