Restore single table

Can someone please help me with the command to restore a single table using psql. Took the backup using below command : pg_dump -t (tablename) dbname > tablename.sql

Re: Restore single table

psql -d databaseName -f tablename.sql On Wed, Oct 30, 2019, 5:51 PM Sonam Sharma wrote: > Can someone please help me with the command to restore a single table > using psql. > > Took the backup using below command : > pg_dump -t (tablename) dbname > tablename.sql >

Re: Automatically parsing in-line composite types

On Tue, Oct 29, 2019 at 12:58 PM Mitar wrote: > > Hi! > > On Tue, Oct 29, 2019 at 9:06 AM Fabio Ugo Venchiarutti > wrote: > > You can use subqueries and array_agg() to deepen your output tree all > > the way to a stack overflow, a single _to_json() call at the > > top will recursively traverse an

Re: Automatically parsing in-line composite types

Hi! On Wed, Oct 30, 2019 at 8:37 AM Merlin Moncure wrote: > Check out libpqtypes: https://github.com/pgagarinov/libpqtypes Interesting. I have looked at the code a bit but I do not find how it determines the type for inline compound types, like the ones they appear in my original SQL query examp

RE: Can you please tell us how set this prefetch attribute in following lines.

Thanks Thompson. Your inputs are very valuable and we successfully implemented it and results are very good. But I am getting following error message. Can you please suggest why this is coming and what is the remedy for this. Error Details - Failed to execute the sql command cl

Re: Automatically parsing in-line composite types

On 30/10/2019 16:15, Mitar wrote: Hi! On Wed, Oct 30, 2019 at 8:37 AM Merlin Moncure wrote: Check out libpqtypes: https://github.com/pgagarinov/libpqtypes Interesting. I have looked at the code a bit but I do not find how it determines the type for inline compound types, like the ones the

Upgrade procedure

Hi, all. Why is it normally suggested to stop the server, upgrade it, then start it? Wouldn't it be easier & quicker to simply upgrade the package in-place and restart the service? On OSen that allow modification of currently running binaries, which is most Unix OS, M$ Windows being a notable e

Getting following error in using cursor to fetch the records from a large table in c language

Hi all, Getting following error in using cursor to fetch the records from a large table in c language. Can you please suggest why it is coming and what is the remedy for this. Error Details - Failed to execute the sql command close: mycursor_4047439616_1571970686004430275

Re: Upgrade procedure

On Wed, Oct 30, 2019 at 6:00 PM rihad wrote: > Hi, all. Why is it normally suggested to stop the server, upgrade it, > then start it? Wouldn't it be easier & quicker to simply upgrade the > package in-place and restart the service? On OSen that allow > modification of currently running binaries, w

Re: Getting following error in using cursor to fetch the records from a large table in c language

On Wed, 2019-10-30 at 16:59 +, M Tarkeshwar Rao wrote: > Getting following error in using cursor to fetch the records from a large > table in c language. > Can you please suggest why it is coming and what is the remedy for this. > > Error Details > - > Failed to execute the sq

Re: Automatically parsing in-line composite types

On Wed, Oct 30, 2019 at 11:15 AM Mitar wrote: > > Hi! > > On Wed, Oct 30, 2019 at 8:37 AM Merlin Moncure wrote: > > Check out libpqtypes: https://github.com/pgagarinov/libpqtypes > > Interesting. I have looked at the code a bit but I do not find how it > determines the type for inline compound ty

Re: Automatically parsing in-line composite types

Hi, On 2019-10-29 14:33:00 -0400, Tom Lane wrote: > Mitar writes: > > I think RowDescription should be extended to provide full recursive > > metadata about all data types. That would be the best way to do it. > > [ shrug... ] In a world where stability of the wire protocol were > of zero value

RE: Upgrade procedure

>From: rihad >Hi, all. Why is it normally suggested to stop the server, upgrade it, then >start it? Wouldn't it be easier & quicker to simply upgrade the package >in-place and restart the service? On OSen that allow modification of currently >running binaries, which is most Unix OS, M$ Windows

Re: Automatically parsing in-line composite types

Hi! On Wed, Oct 30, 2019 at 3:06 PM Merlin Moncure wrote: > It looks it up from the database. Yes, this is how I started doing it in my prototype as well. > Correct. Only declared (via CREATE TYPE) composite types will work due > to protocol limitations. Exactly. This is where I got stuck, so

RE: Getting following error in using cursor to fetch the records from a large table in c language

Hi Laurenz, You are absolutely right. This is the issue with us. If we retry the query again. Will it be successful? Can you please suggest how to configure hot_standby_feedback? Regards Tarkeshwar -Original Message- From: Laurenz Albe Sent: Wednesday, October 30, 2019 11:20 PM To: M

Can you please suggest how to configure hot_standby_feedback?

Hi all, Can you please suggest how to configure hot_standby_feedback? Regards Tarkeshwar

Re: Upgrade procedure

>From: rihad Hi, all. Why is it normally suggested to stop the server, upgrade it, then start it? Wouldn't it be easier & quicker to simply upgrade the package in-place and restart the service? On OSen that allow modification of currently running binaries, which is most Unix OS, M$ Windows b

Re: Getting following error in using cursor to fetch the records from a large table in c language

On Thu, 2019-10-31 at 05:18 +, M Tarkeshwar Rao wrote: [queries get canceled on the standby] > You are absolutely right. This is the issue with us. > If we retry the query again. Will it be successful? Sometimes :^/ > Can you please suggest how to configure hot_standby_feedback? You set it