\set \e and newline

2022-02-24 Thread Wim Bertels
Hello, a quick question about https://www.postgresql.org/docs/current/app-psql.html and the \set option it seems that \set does not interpret an 'enter' interactively the same as an 'enter' in a short script made with \e ### * case 1: postgres=# \set x 1 postgres=# select :x; ?column? ---

Re: tsvector string representation and parsing

2022-02-24 Thread Tom Lane
=?UTF-8?Q?Johannes_Gra=c3=abn?= writes: > Before using format(), I tried just generating those strings by doubling > any single quote or backslash and enclosing the whole string in single > quotes, but that didn't seem a safe way, though it works in principle: That's the documented requirement,

alter table to multi partitions

2022-02-24 Thread Catalin Maftei
hello, on a project I have large tables, with more than 2-5.000.000 rows, and the system is starting to be slow,This tables have many dependencies functions, procedures and views. I want to partition this tables.  I think for this scenario for table Orders: step1: create new table with same