Ask a Question related to PostgreSQL / PGSQL, Design and Development.
-
raptor #1
dumping the schema ?
hi,
how can I dump the db schema so that I can recrate the DB later ?
tia
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
[url]http://archives.postgresql.org[/url]
raptor Guest
-
dumping roles
Originally posted by: ianwinter Not as such. Why not? The data needs to be stored somewhere for IsUserInRole to read it, so why isn't there a... -
Dumping Scheduled Tasks
Probably a little late now but maybe it will help someone else. The answer depends on your version of CF. If CF5 then they should be in the... -
dumping database
sorry in addition to my last question, does anyone know if it's possible for a web service/site to "dump" out a snapshot of a subset of a... -
column dumping
Hi, is there a smart command line ( Unix ) utility to dump out a particular column to the STDOUT/file from a file containing multi column data ?... -
Dumping values of all vars
Hello, Is it possible to dump the values of all the vars in a perl script easily? I want to have a sub called Error that when called will tell me... -
Lonni J Friedman #2
Re: dumping the schema ?
On Sat, 29 Jan 2005 21:55:23 +0200, raptor <raptor@tvskat.net> wrote:
> hi,
> how can I dump the db schema so that I can recrate the DB later ?
From 'man pg_dump':
-s
--schema-only
Dump only the schema (data definitions), no data.
--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~~~~~~~~~
L. Friedman [email]netllama@gmail.com[/email]
LlamaLand [url]http://netllama.linux-sxs.org[/url]
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
[url]http://archives.postgresql.org[/url]
Lonni J Friedman Guest



Reply With Quote

