[ADMIN] RESTORE SCHEMA

Hey Guys, This is my first email to list. Hope i will get the solution quickly. I am working on postgresql 8.1 I have a DB, with mre than 4 schemas. I want to take backup of one of the schema and restore the same schema into another DB .ofcourse schema names are same. I am able to take

Re: [ADMIN] RESTORE SCHEMA

On 1/23/07, Kranti [EMAIL PROTECTED] wrote: Hey Guys, This is my first email to list. Hope i will get the solution quickly. Hi, please use pg_dump -n option to select schema. Read manual pages of pg_dump.I am not sure how to do it in pgadminIII all said it is doable. regds malah. I am

Re: [ADMIN] Install XML on Postgres 8.1

Can we compare the same powerful like Oracle has on Xml? I don't think so that current xml2 support is according to the SQL 2003 standards and for now it is I guess just the basic one. -- Shoaib Mir EnterpriseDB (www.enterprisedb.com) On 1/22/07, Rajesh Kumar Mallah [EMAIL

Re: [ADMIN] server process (PID xxx) was terminated by signal 7

Στις Δευτέρα 22 Ιανουάριος 2007 18:01, γράψατε: Achilleas Mantzios [EMAIL PROTECTED] writes: In one of our remote pgsql 7.4.2 installations (no tcp/ip, no mgetty dialin works always), i got the above message. Since you have not told us what the platform is, there is no way to guess what

Re: [ADMIN] Function with Array

Hi Ivo, Tentei a sua sugestão... alterei a função para retornar a primeira posição do ARRAY ($1[1]), mas agora a função retorna um erro. Para executar a função digito o seguinte comando: select SMART.TB_ADM_CEP_SEL1('{4,3}') Mas dá o seguinte erro: ERROR: array value must start with { or

[ADMIN] Print command equivalent in postgresql

Hi, In SQL Server there is a PRINT command that returns a user-defined message to the client. What is the equivalent of this on postgresql .?? Regards

Re: [ADMIN] Print command equivalent in postgresql

Negandhi, Nishith escreveu: Hi, In SQL Server there is a PRINT command that returns a user-defined message to the client. What is the equivalent of this on postgresql .?? Regards I may use the raise notice if you are in stored procedure. -- Ivo Nascimento Iann tech - Desenvolvendo

Re: [ADMIN] server process (PID xxx) was terminated by signal

Bruce Momjian wrote: Is there no API to return the name of signals? There is, but it's not portable. If someone wants to perform an exercise in writing configure code, look for strsignal() and sys_siglist[]. -- Peter Eisentraut http://developer.postgresql.org/~petere/

Re: [ADMIN] Install XML on Postgres 8.1

Shoaib Mir wrote: Can we compare the same powerful like Oracle has on Xml? I don't think so that current xml2 support is according to the SQL 2003 standards and for now it is I guess just the basic one. The functionality of the xml2 contrib module is almost completely orthogonal to what the

Re: [ADMIN] Install XML on Postgres 8.1

Peter Eisentraut wrote: Shoaib Mir wrote: Can we compare the same powerful like Oracle has on Xml? I don't think so that current xml2 support is according to the SQL 2003 standards and for now it is I guess just the basic one. The functionality of the xml2 contrib module is almost

Re: [ADMIN] Install XML on Postgres 8.1

Joshua D. Drake wrote: PeterE do you have a specific TODO I can line item for the pending 8.3 release? http://developer.postgresql.org/index.php/XML_Todo -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadcast)--- TIP

Re: [ADMIN] Install XML on Postgres 8.1

On 1/22/07, Alexander B. [EMAIL PROTECTED] wrote: Hi, I need to install XML on Postgres 8.1. What's the simples steps that I can follow? I found on the internet, but there are many versions, packages and ways to install. What's the right way to install? Can we compare the same powerful like