[HACKERS] pg_dump -- data and schema only?

2005-08-04 Thread Mark Woodward
I haven't seen this option, and does anyone thing it is a good idea?

A option to pg_dump and maybe pg_dump all, that dumps only the table
declarations and the data. No owners, tablespace, nothing.

This, I think, would allow more generic PostgreSQL data transfers.

---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
   subscribe-nomail command to [EMAIL PROTECTED] so that your
   message can get through to the mailing list cleanly


Re: [HACKERS] pg_dump -- data and schema only?

2005-08-04 Thread Tino Wildenhain
Am Donnerstag, den 04.08.2005, 10:26 -0400 schrieb Mark Woodward:
 I haven't seen this option, and does anyone thing it is a good idea?
 
 A option to pg_dump and maybe pg_dump all, that dumps only the table
 declarations and the data. No owners, tablespace, nothing.
 
 This, I think, would allow more generic PostgreSQL data transfers.

pg_dump -s maybe?

See man pg_dump: 

   -s

   --schema-only
  Dump only the object definitions (schema), not data.

Usually one dumps the database with -Fc and then construct
SQL for data and DDL via pg_restore from this binary dump.
You can then use pg_restore -l, edit (for example via sed)
and use it with -L to only generate SQL for these objects.

-- 
Tino Wildenhain [EMAIL PROTECTED]


---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
   subscribe-nomail command to [EMAIL PROTECTED] so that your
   message can get through to the mailing list cleanly


Re: [HACKERS] pg_dump -- data and schema only?

2005-08-04 Thread Mark Woodward
 Am Donnerstag, den 04.08.2005, 10:26 -0400 schrieb Mark Woodward:
 I haven't seen this option, and does anyone thing it is a good idea?

 A option to pg_dump and maybe pg_dump all, that dumps only the table
 declarations and the data. No owners, tablespace, nothing.

 This, I think, would allow more generic PostgreSQL data transfers.

 pg_dump -s maybe?

 See man pg_dump:

-s

--schema-only
   Dump only the object definitions (schema), not data.

 Usually one dumps the database with -Fc and then construct
 SQL for data and DDL via pg_restore from this binary dump.
 You can then use pg_restore -l, edit (for example via sed)
 and use it with -L to only generate SQL for these objects.


Actually, there isn't a setting to just dump the able definitions and the
data. When you dump the schema, it includes all the tablespaces,
namespaces, owners, etc.

Just the table nd object declarations and data would be useful.

---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster


Re: [HACKERS] pg_dump -- data and schema only?

2005-08-04 Thread Tino Wildenhain
Am Donnerstag, den 04.08.2005, 11:52 -0400 schrieb Mark Woodward:
  Am Donnerstag, den 04.08.2005, 10:26 -0400 schrieb Mark Woodward:
  I haven't seen this option, and does anyone thing it is a good idea?
 
  A option to pg_dump and maybe pg_dump all, that dumps only the table
  declarations and the data. No owners, tablespace, nothing.
 
  This, I think, would allow more generic PostgreSQL data transfers.
 
  pg_dump -s maybe?
 
  See man pg_dump:
 
 -s
 
 --schema-only
Dump only the object definitions (schema), not data.
 
  Usually one dumps the database with -Fc and then construct
  SQL for data and DDL via pg_restore from this binary dump.
  You can then use pg_restore -l, edit (for example via sed)
  and use it with -L to only generate SQL for these objects.
 
 
 Actually, there isn't a setting to just dump the able definitions and the
 data. When you dump the schema, it includes all the tablespaces,
 namespaces, owners, etc.
 
 Just the table nd object declarations and data would be useful.

Reread my comment on the -l / -L option to pg_restore. You can
do all that with it :-)

-- 
Tino Wildenhain [EMAIL PROTECTED]


---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
   choose an index scan if your joining column's datatypes do not
   match


Re: [HACKERS] pg_dump -- data and schema only?

2005-08-04 Thread Tom Lane
Mark Woodward [EMAIL PROTECTED] writes:
 Actually, there isn't a setting to just dump the able definitions and the
 data. When you dump the schema, it includes all the tablespaces,
 namespaces, owners, etc.

 Just the table nd object declarations and data would be useful.

pg_dump -t table ?

regards, tom lane

---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
   subscribe-nomail command to [EMAIL PROTECTED] so that your
   message can get through to the mailing list cleanly


Re: [HACKERS] pg_dump -- data and schema only?

2005-08-04 Thread Mark Woodward
 Mark Woodward [EMAIL PROTECTED] writes:
 Actually, there isn't a setting to just dump the able definitions and
 the
 data. When you dump the schema, it includes all the tablespaces,
 namespaces, owners, etc.

 Just the table nd object declarations and data would be useful.

 pg_dump -t table ?

I guess what I'm not being very clear.

pg_dump -# mydb

--
-- PostgreSQL database dump
--

SET client_encoding = 'SQL_ASCII';
SET check_function_bodies = false;
SET client_min_messages = warning;

SET default_with_oids = true;

--
-- Name: rtz; Type: TABLE; Schema: public; Owner: markw; Tablespace:
--

CREATE TABLE rtz (
tlid integer,
rtsq integer,
zip4l integer,
zip4r integer
);

--
-- Data for Name: rtz; Type: TABLE DATA; Schema: public; Owner: markw
--

COPY rtz (tlid, rtsq, zip4l, zip4r) FROM stdin;
208014102   0   0   0
208014098   0   0   0
207023736   0   0   0
208014112   0   0   0
207027749   0   0   0

.

That way, it can go easily between various PG versions.

---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster