I am an ex-Informix convert. Informix used the term schema to refer
to the SQL-format definition of how a table or view was created. E.g.,
CREATE TABLE john ( char(8) lid, ...); Some views we have are quite
complex (and not created by me) and I want to create a similar one in
Pg. If I
On Tue, 2007-07-03 at 12:22 -0400, Mark Fenbers wrote:
I am an ex-Informix convert. Informix used the term schema to refer
to the SQL-format definition of how a table or view was created. E.g.,
CREATE TABLE john ( char(8) lid, ...); Some views we have are quite
complex (and not created
Mark Fenbers wrote:
I am an ex-Informix convert. Informix used the term schema to refer
to the SQL-format definition of how a table or view was created.
E.g., CREATE TABLE john ( char(8) lid, ...); Some views we have are
quite complex (and not created by me) and I want to create a similar
pg_dump dbname -s -t tableorindexname
[Also an Informix DBA] Is there a way to tweak the output of pg_dump
when used in this manner to omit the verbose commentary.
$ pg_dump OGo -s -t enterprise
--
-- Name: unique_enterprise_login; Type: INDEX; Schema: public; Owner:
OGo; Tablespace:
--
On 7/3/07, Adam Tauno Williams [EMAIL PROTECTED] wrote:
pg_dump dbname -s -t tableorindexname
[Also an Informix DBA] Is there a way to tweak the output of pg_dump
when used in this manner to omit the verbose commentary.
no AFAIK. dbexport and dbschema doesn't have that either, or they
Adam Tauno Williams skrev:
pg_dump dbname -s -t tableorindexname
[Also an Informix DBA] Is there a way to tweak the output of pg_dump
when used in this manner to omit the verbose commentary.
$ pg_dump OGo -s -t enterprise
pg_dump OGo -s -t enterprise | grep -v '^--$'
Nis