Re: Possible to dump/load a database from within psql? - Mailing list pgsql-general

From Raymond O'Donnell
Subject Re: Possible to dump/load a database from within psql?
Date
Msg-id 56A5FF41.1080205@iol.ie
Whole thread Raw
In response to Possible to dump/load a database from within psql?  (Brian Cardarella <brian@dockyard.com>)
List pgsql-general
On 25/01/2016 10:16, Brian Cardarella wrote:
> Is it possible, and if so how, to dump and then load a database to/from
> a file from within a psql connection?

You can use the COPY command to do a table at a time, but you'll get
just the data - you won't get permissions etc.

Ray.

--
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie


pgsql-general by date:

Previous
From: Vik Fearing
Date:
Subject: Re: TABLESAMPLE usage
Next
From: Simon Riggs
Date:
Subject: Re: TABLESAMPLE usage