Re: [GENERAL] dump schema schema only?

[Rick Seeger]

You can use -t to specify a table:

% pg_dump -s database -t tablename


-Rick



-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Patrick
Hatcher
Sent: Wednesday, October 29, 2003 12:57 PM
To: [EMAIL PROTECTED]
Subject: [GENERAL] dump schema schema only?


I have a development server where I, well, do my development.
Occasionally,
I will create a new schema within an existing database that I would
like to
use on my production machine.   I know that doing a pg_dump -s

> somefile.sql will dump the entire schema of the database, but is
there a
way to export only schema X from the database?

TIA
Patrick Hatcher



---(end of
broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to
[EMAIL PROTECTED])




---(end of broadcast)---
TIP 8: explain analyze is your friend

[GENERAL] Can anyone recommend a good PostGres admin tool?

[Rick Seeger]

We're looking for a (preferrably free) Windows (or browser) based PG
admin tool to use in our office. I've only ever used the psql command
line interface, so I don't have any experience with the GUI tools out
there. Any help appreciated.

Cheers,
Rick




---(end of broadcast)---
TIP 3: 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: [GENERAL] career in SQL/Database administration

[Rick Seeger]

> (Anybody with suggestions on what to do with people like this please
> feel free to chime in.  :-D)

In situations where the client is not tech saavy or the scope is
ambiguous, we bid high and ask for a 50% deposit. I think the best
scenario is to get the client to pay for a detailed spec so they are
clear on the deliverables beforehand and there are no disputes about
what is in scope later on. In general though, we avoid fixed-rate jobs
if possible (If you're paid hourly, then revisions and scope creep are
good things.)







---(end of broadcast)---
TIP 8: explain analyze is your friend