Re: how can I fix my accent issues?

On Fri, 2023-12-08 at 23:58 -0500, Igniris Valdivia Baez wrote: > hello, I have an ETL process collecting data from a postgresql > database and xls files and inserting in a postgresql database that > process occurs great in a local DB in postgres 14 with UTF8 > codification and Spanish_Cuba.1952 co

how can I fix my accent issues?

hello, I have an ETL process collecting data from a postgresql database and xls files and inserting in a postgresql database that process occurs great in a local DB in postgres 14 with UTF8 codification and Spanish_Cuba.1952 collation but when I execute that process in dev which is in postgres 15 a

Re: Inserting into foreign table with sequences and default values

Correction: the trigger on the remote table isn't going to work. I was trying so many different things today that I confused myself. Sorry... On the bright side the remote sequence works great and I can insert records from the my database to the remote database now which is a step forward. I

Re: Inserting into foreign table with sequences and default values

Thanks Tom, Your reply helped point me in the right direction. With a little trial and error I came up with a hack to solve my issue. First off, I create a shared sequence for the user_id with a technique described here: [ https://paquier.xyz/postgresql-2/global-sequences-with-postgres_fdw

Re: Store PDF files in PostgreDB

On 2023-12-06 09:43:27 -0500, Ron Johnson wrote: > On Wed, Dec 6, 2023 at 9:39 AM Priyadharshini Vellaisamy > > wrote: > Please let m know can we store PDF files in PostgreDB ? > > > You can store anything up to 1GB in Postgresql using data type bytea. >   > > If so, can we retrieve it

Re: Inserting into foreign table with sequences and default values

"peter.boris...@kartographia.com" writes: > I guess the FDW is not "seeing" the default value for status and the > bigserial sequence for the id column. Is there anyway around this? The idea is that you should attach default clauses to the foreign table definition. A remote serial column is a h

Re: running \copy through perl dbi ?

On Fri, 8 Dec 2023 10:45:28 -0500 David Gauthier wrote: > > I'm trying to run a PG client side "\copy" command from a perl script. I > tried using $dbh->do("\\copy ...") but it barffed when it saw the '\'... > ERROR: syntax error at or near "\" Hi David, This works for me : #create file

Inserting into foreign table with sequences and default values

Hello, I have a few questions inserting data using Foreign Data Wrappers (FDW). Consider this simple example. On PostgreSQL Database A (remote): CREATE TABLE APP.TEST ( ID BIGSERIAL NOT NULL, FIRST_NAME text, LAST_NAME text, STATUS integer NOT NULL DEFAULT 1, CONSTRAINT

Re: running \copy through perl dbi ?

On Fri, Dec 8, 2023 at 9:01 AM Adrian Klaver wrote: > On 12/8/23 07:45, David Gauthier wrote: > > Hi: > > > > I'm trying to run a PG client side "\copy" command from a perl script. > > I tried using $dbh->do("\\copy ...") but it barffed when it saw the > '\'... > > ERROR: syntax error at or near

Re: running \copy through perl dbi ?

On 12/8/23 07:45, David Gauthier wrote: Hi: I'm trying to run a PG client side "\copy" command from a perl script. I tried using $dbh->do("\\copy ...") but it barffed when it saw the '\'... ERROR:  syntax error at or near "\" I can do this with a command line approach, attaching to the DB  t

Re: running \copy through perl dbi ?

On Fri, Dec 8, 2023 at 8:45 AM David Gauthier wrote: > > I'm trying to run a PG client side "\copy" command from a perl script. I > tried using $dbh->do("\\copy ...") but it barffed when it saw the '\'... > ERROR: syntax error at or near "\" > More accurately it is the psql application's meta-

running \copy through perl dbi ?

Hi: I'm trying to run a PG client side "\copy" command from a perl script. I tried using $dbh->do("\\copy ...") but it barffed when it saw the '\'... ERROR: syntax error at or near "\" I can do this with a command line approach, attaching to the DB then run using... -c "\copy ...". But I was

Re: Invalid Parent Index Issue Will Not Resolve Despite Multiple Attempts To Fix

Thank you for your response. I forgot to include it but we did check for that prior to our submission. We used this query to see how many indexes were related to the parent index via the inherits table: SELECT count(inh.inhrelid) FROM pg_class c inner join pg_inherits inh on c.oid = inh.inhparent

Re: Disable script execution in server level when updating via grids

I'd use different users or roles for that - one with more restricted rights. I'm not sure how to do it in your specific client. In general, your user can be granted be granted read-only access and a more powerful role to which it can switch explicitly. mydb=> CREATE TABLE x (id INT); ERROR: