[SQL] pgdump by schema?

Is there a way to dump everything in a particular schema? Bradley Miller NUVIO CORPORATION Phone: 816-444-4422 ext. 6757 Fax: 913-498-1810 http://www.nuvio.com [EMAIL PROTECTED]

Re: [SQL] pgdump by schema?

am Wed, dem 02.02.2005, um 9:33:22 -0600 mailte Bradley Miller folgendes: > Is there a way to dump everything in a particular schema? RTFM. man pg_dump, search for --schema Regards, Andreas -- Diese Message wurde erstellt mit freundlicher Unterstützung eines freilau- fenden Pinguins aus artg

Re: [SQL] pgdump by schema?

From: pg_dump --help -n, --schema=SCHEMA dump the named schema only > Is there a way to dump everything in a particular schema? > > > Bradley Miller > NUVIO CORPORATION > Phone: 816-444-4422 ext. 6757 > Fax: 913-498-1810 > http://www.nuvio.com > [EMAIL PROTECTED] -- This message has

Re: [SQL] pgdump by schema?

On Wed, Feb 02, 2005 at 09:33:22AM -0600, Bradley Miller wrote: > Is there a way to dump everything in a particular schema? See the documentation for pg_dump. In PostgreSQL 7.4 and later, pg_dump has a --schema (-n) option. -- Michael Fuhr http://www.fuhr.org/~mfuhr/

[SQL] locale with os x

The solution to locales on OS X. initdb --locale=es_ES.ISO8859-1 ~/testdb worked great the settings are at: /usr/share/locale/ I asked on the OS X discussion board in the UNIX section... Ted __ Do you Yahoo!? Yahoo! Mail - Easier th

Re: [SQL] pgdump by schema?

Thanks -- I was looking at a book and it didn't mention the schema dump . . . should have done the man or --help before asking. On Feb 2, 2005, at 9:46 AM, Adam Witney wrote: From: pg_dump --help -n, --schema=SCHEMA dump the named schema only Bradley Miller NUVIO CORPORATION Phone: 816-

[SQL] pg_restore problem

I'm attempting to restore a dump from one server to another (one is a Mac and one is a Linux base, if that makes any difference). I keep running into issues like this: pg_restore: [archiver (db)] could not execute query: ERROR: function public.random_page_link_id_gen() does not exist This is wh

Re: [SQL] pg_restore problem

I used pgadmin to save and mine would not restore saying something about the encoding. I will have to be able to save and restore reliably as well.   Also I never heard anything further on the query running slow (I put up table defs and analyze with and without seq on). I am running int

[SQL] PL/PgSQL - returning multiple columns ...

I have a function that I want to return 'server_name, avg(load_avg)' ... if I wanted to return matching rows in a table, I can do a 'setof ', with a for loop inside ... but what do I set the 'RETURNS' to if I want to return the results of query that returns only two fields of a table, or, in th

Re: [SQL] pg_restore problem

Bradley Miller <[EMAIL PROTECTED]> writes: > I'm attempting to restore a dump from one server to another (one is a > Mac and one is a Linux base, if that makes any difference). I keep > running into issues like this: > pg_restore: [archiver (db)] could not execute query: ERROR: function > pub

Re: [SQL] PL/PgSQL - returning multiple columns ...

Hi Marc, One option is to create a simple data type and return the rowtype of the datatype eg CREATE TYPE tserverload AS ("server_name" text, "load_avg" int4); CREATE FUNCTION getserverload() RETURNS tserverload AS 'DECLARE r tserverload%rowtype; etc. You would then return r, comprise

[SQL] problem with postgres

Dear friends I hope some one can help me Server machine celeron 2.4Gb with 512 Ram postgres 7.4.5 conectiva 8 with kernel 2.4.19 i´m getting many message of Erro:canceling query due to user request how to solve this i even get with an just booted up server, and running vacuum analyze verbose insid

[SQL] plpgsql functions to 'C' functions

I would like to convert all my plpgsql functions to their 'C' equivalent coded functions. Does anyone have experience in this matter? Thank you, Peter ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archive

[SQL] problem with postgres

Dear friends I hope some one can help me Server machine celeron 2.4Gb with 512 Ram postgres 7.4.5 conectiva 8 with kernel 2.4.19 i´m getting many message of Erro:canceling query due to user request how to solve this i even get with an just booted up server, and running vacuum analyze verbose insid

[SQL] problem while converting sybase quries to postgres

The following is a sybase query and i am trying to convet it into postgres but in postgres the join will be specified in from clause and we cannot specify any logical operator   i would be grateful if you could tell me the solution for it SELECT t1.SR_TRAN_HEAD_PK AS ReceiptHeaderPK, t1.A

Re: [SQL] plpgsql functions to 'C' functions

On Wed, Feb 02, 2005 at 05:57:10AM -0800, Peter Manchev wrote: > I would like to convert all my plpgsql functions to their 'C' equivalent > coded functions. Why? What problem are you trying to solve? > Does anyone have experience in this matter? See "C-Language Functions" in the documentation

Re: [SQL] problem with postgres

On Wed, Feb 02, 2005 at 11:33:03PM -0200, Luiz Rafael Culik Guimaraes wrote: > i´m getting many message of > Erro:canceling query due to user request What does the following query show? SHOW statement_timeout; If statement_timeout isn't 0 (zero) and if you didn't change it in postgresql.conf, t