Looking for a "show create table " equivalent
От | B.Rathmann |
---|---|
Тема | Looking for a "show create table |
Дата | |
Msg-id | 4E1C06BD.5080606@ping.de обсуждение исходный текст |
Ответы |
Re: Looking for a "show create table Re: Looking for a "show create table Re: Looking for a "show create table |
Список | pgsql-sql |
Hello, I've been trying to find out how to find out which sql was run to create a certain table. As I need this in a program which may access the database remotely, using pg_dump --schema-only or psql is not an option (the system my program runs on may not even have those tools installed). Looking at the source of pgadmin3 it seems as if the program collects all info about the given table (columns, indeces etc) and creates the needed SQL by itself, is there no easier way? E.g. MySQL offers a simple "show create table <name>". I am using Postgresql 9.0.4 on Gentoo. Thanks for your help (if there is any documentation which I haven't found yet, just point me to it). Sincerely Bettina
В списке pgsql-sql по дате отправления: