Re: Get attributes names

2019-01-24 Thread ramsiddu007
Hi Arthur, Thanks for your help. But am using postgres 9.6 version. On Thu, 24 Jan 2019, 15:24 Arthur Zakirov On 24.01.2019 11:54, ramsiddu007 wrote: > > Dear all, > >I hope you are all doing well. Today i got one > > requirement, for that i ne

Get attributes names

2019-01-24 Thread ramsiddu007
Dear all, I hope you are all doing well. Today i got one requirement, for that i need attribute names as below example. Xml: In the above sample input xml, i want attributes list of emp_deails like. Attributes ___ emp_id emp_name dept Thanking you,

Re: Newly Created Source DB Table Not Reflecting into Destination Foreign Tables

2018-12-11 Thread ramsiddu007
Ok, I will check. Thanks a lot. On Tue, 11 Dec 2018 at 21:16, Adrian Klaver wrote: > On 12/11/18 7:28 AM, ramsiddu007 wrote: > > Please reply to list also. > Ccing list. > > > Thanks for giving reply. > > 1. Postgres Version: 11 > > > > 2. Below Datab

Newly Created Source DB Table Not Reflecting into Destination Foreign Tables

2018-12-11 Thread ramsiddu007
Dear Professionals, I hope you are doing well. I am looking *Foreign Data Wrappers*. In this way I have created a data wrapper in destination database. But at the time of creating wrapper, server and user mappings, source database having only 1 table. After creating wrapp

Re: Empty Range Bound Specified for Partition

2018-11-22 Thread ramsiddu007
Thank you for the clarification. On Thu, 22 Nov 2018 at 13:30, Alban Hertroys wrote: > > > On 22 Nov 2018, at 7:21, ramsiddu007 wrote: > > > > pgsql> create table test_upto_100 partition of test_parent_partition > > for values from ('51') t

Empty Range Bound Specified for Partition

2018-11-21 Thread ramsiddu007
Dear Professionals, Just i have installed "PostgreSQL 11.1". And i have started to create partitions. I've created RANGE partition table as like below. pgsql> create table test_parent_partition( item_id integer, item_name character varying, item_qty cha

Re: 65279 Invisible ASCII Character

2018-07-17 Thread ramsiddu007
Thanks, I'll look into it. On Tue, Jul 17, 2018 at 3:42 PM Christoph Moench-Tegeder wrote: > ## ramsiddu007 (ramsiddu...@gmail.com): > > > If i remove first character it's run. That first > > character is invisible, I have checked that *ascii* value, it is *652