Re: [ADMIN] Dump Schema?

2001-07-27 Thread Chris Ruprecht
Thanks all who responded, I got that working just fine ;-). I should read the manual some time ...   To my surprise, I saw my Pl/PGSQL procedures (functions) dumped there as well. Is there any way to 'encode' them so that the end user is not able to read them in clear text and (heavens forbid

Re: [ADMIN] Dump Schema?

2001-07-27 Thread Karel Zak
On Fri, Jul 27, 2001 at 08:55:05AM -0500, Chris Ruprecht wrote: > Hi guys, > > I have a database on my production machine and I want a copy of this db (9 GB) - >without the data - on a development machine (notebook with about 6 GB of space). > How can I just dump the schema without the data? Is

Re: [ADMIN] Dump Schema?

2001-07-27 Thread George Lewis
pg_dump -s dbname Chris Ruprecht ([EMAIL PROTECTED]) wrote: > Hi guys, > > I have a database on my production machine and I want a copy of this db (9 GB) - >without the data - on a development machine (notebook with about 6 GB of space). > How can I just dump the schema without the data? Is the

[ADMIN] Dump Schema?

2001-07-27 Thread Chris Ruprecht
Hi guys,   I have a database on my production machine and I want a copy of this db (9 GB) - without the data - on a development machine (notebook with about 6 GB of space). How can I just dump the schema without the data? Is there a simple command for that?   Best regards, Chris