In response to Igor Katson : > Is there a way to get i.e. table creation sql script from an existing > table in psql (not postgresql, but psql client), like it is in pgAdmin? > > I.e. i point it to existing table 'foo', and it writes: > CREATE TABLE foo ( > bar int > ); wait for 8.4: http://developer.postgresql.org/pgdocs/postgres/functions-info.html - pg_get_functiondef(func_oid) - pg_get_indexdef(index_oid) - pg_get_ruledef(rule_oid) - pg_get_triggerdef(trigger_oid) - pg_get_viewdef(view_name) Unfortunately, i can't see such a function for tabledef. Andreas -- Andreas Kretschmer Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header) GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
