[SQL] Informix Schema - PostgreSQL ?

2007-07-03 Thread Mark Fenbers
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

Re: [SQL] Informix Schema - PostgreSQL ?

2007-07-03 Thread Adam Tauno Williams
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

Re: [SQL] Informix Schema - PostgreSQL ?

2007-07-03 Thread Scott Marlowe
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

Re: [SQL] Informix Schema - PostgreSQL ?

2007-07-03 Thread Adam Tauno Williams
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: --

Re: [SQL] Informix Schema - PostgreSQL ?

2007-07-03 Thread Jaime Casanova
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

Re: [SQL] Informix Schema - PostgreSQL ?

2007-07-03 Thread Nis Jørgensen
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