postgres=# select system('pg_dump -s -t orasup_test1 dbinfo2 |egrep -v "^--|^$"');
system
-----------------------------------------------------
SET statement_timeout = 0; +
SET lock_timeout = 0; +
SET idle_in_transaction_session_timeout = 0; +
SET client_encoding = 'UTF8'; +
SET standard_conforming_strings = on; +
SET check_function_bodies = false; +
SET client_min_messages = warning; +
SET row_security = off; +
SET search_path = public, pg_catalog; +
SET default_tablespace = ''; +
SET default_with_oids = false; +
CREATE TABLE orasup_test1 ( +
a integer, +
b character varying(200) +
); +
ALTER TABLE orasup_test1 OWNER TO djidba_rw; +
CREATE INDEX idx_b ON orasup_test1 USING btree (b);+
(1 row)
postgres=#
postgres=#