Postgresq, get table definition, pg_get_tabledef

Question

Hi!

Do you know what happend with pg_get_tabledef function in postgresql 8.4? I'm sure I've been using it with previous versions of postgresql?

I need to get sql 'create table' syntax for existing table in db with indexes, defaults as so on... Maybe they replaced it with something else?

Answer 1

Take a look at the \dt command at http://www.postgresql.org/docs/8.4/interactive/app-psql.html

You might want to start the terminal with the -E parameter

-E
--echo-hidden
Echo the actual queries generated by \d and other backslash commands. You can use this to study psql's internal operations. This is equivalent to setting the variable ECHO_HIDDEN from within psql.

edit and btw:

http://markmail.org/message/3obwktwfnxfwspxg?q=pg_get_tabledef+type%3Aannouncements:

== PostgreSQL Weekly News - March 31 2007 ==
[...}
Bruce Momjian committed:
[...]
- Remove TODO due to lack of interest: "Add pg_get_acldef(), pg_get_typedefault(), pg_get_attrdef(), pg_get_tabledef(), pg_get_domaindef(), pg_get_functiondef()."