Hi,
I am looking for an easy way to backup views and functions. I want to
store them in our version control system.
Using pgAdmin I can access them one at a time. I am looking for a better
reporting mechanism. psql shell command for such report will be just fine.
Sorry for the lame question
Hello
2010/8/30 David Harel :
> Hi,
>
> I am looking for an easy way to backup views and functions. I want to store
> them in our version control system.
>
move your functions and view to separate schema - and do backup with
pg_dump -n schema
regards
Pavel Stehule
> Using pgAdmin I can access
Hi.
I am looking for an easy way to backup views and functions. I want to store
them in our version control system.
Well... As far as I can see, for functions you should go to the 'pg_catalog'
schema, table 'pg_proc'. In column 'prosrc' you will find the original text,
but other attributes a
On Mon, Aug 30, 2010 at 09:21:06PM +0300, David Harel wrote:
> Hi,
>
> I am looking for an easy way to backup views and functions. I want to
> store them in our version control system.
>
> Using pgAdmin I can access them one at a time. I am looking for a better
> reporting mechanism. psql shell
You'll probably have to write something (a function) that pulls the data out
of pg_catalog.
You can get a leg up on that by connecting to psql using -E, which echoes
hidden queries.
If you do a \df+ on a function, you'll see the query PG uses.
ex.
production=# \df+ myschema.*
* QUERY **
hello
2010/8/30 Peter Steinheuser :
> You'll probably have to write something (a function) that pulls the data out
> of pg_catalog.
> You can get a leg up on that by connecting to psql using -E, which echoes
> hidden queries.
> If you do a \df+ on a function, you'll see the query PG uses.
>
the
Hi All,
I am using PostGRES 8.3 in conjunction with ESRI's ArcSDE. ArcSDE allows the
storage of spatial data inside of an PostGRES database. One of the programs
bundled with ESRI's GIS suite is ArcCatalog. ArcCatalog is a spatial data
manager. It is possible to browse and analyze the contents o
On Mon, Aug 30, 2010 at 1:31 PM, Michael Andrew Babb wrote:
> Hi All,
> If I execute a make table query along the lines of “select * into
> SF30001_test from SF30001” I can interact with the table in ArcCatalog just
> fine.
what do
\z SF30001
\z SF30001_test
say about the permissions on the two t
