Re: Display Bytea field

2025-01-10 Thread Erik Wienhold
On 2025-01-09 21:31 +0100, Andy Hartman wrote: > could it be done using Powershell? I use this: https://blog.cleverelephant.ca/2021/04/psql-binary.html But I don't know if that translates to PowerShell. -- Erik Wienhold signature.asc Description: PGP signature

Re: Postgres do not support tinyint?

2025-01-10 Thread Vladlen Popolitov
Dominique Devienne писал(а) 2025-01-10 16:41: On Fri, Jan 10, 2025 at 10:13 AM Vladlen Popolitov wrote: If you really need 1-byte integer, you can use "char" type. Cast it to/from int. See comment at the end of the page https://www.postgresql.org/docs/17/datatype-character.html Hi. What would

Re: Display Bytea field

2025-01-10 Thread Ron Johnson
On Fri, Jan 10, 2025 at 7:49 AM Daniel Verite wrote: [snip] > Alternatively, you could compare image checksums before and > after moving them into postgres. The advantage is that you > don't need to export or view any file, and you compare globally > all your images. If the checksums are identica

Re: Display Bytea field

2025-01-10 Thread Daniel Verite
Andy Hartman wrote: > How thru a simple query can I make sure data matches and I can display it > > On Thu, Jan 9, 2025 at 3:16 PM Andy Hartman wrote: > > > I have migrated over a Table from Mssql that had an Image column I now > > have it in Postgres Within psql, the bytea field can b

Re: Postgres do not support tinyint?

2025-01-10 Thread shammat
Dominique Devienne schrieb am 10.01.2025 um 10:41: > On Fri, Jan 10, 2025 at 10:13 AM Vladlen Popolitov > wrote: >> If you really need 1-byte integer, you can use "char" type. Cast it >> to/from int. See comment at the end of the page >> https://www.postgresql.org/docs/17/datatype-character.html

Re: Postgres do not support tinyint?

2025-01-10 Thread Dominique Devienne
On Fri, Jan 10, 2025 at 10:13 AM Vladlen Popolitov wrote: > If you really need 1-byte integer, you can use "char" type. Cast it > to/from int. See comment at the end of the page > https://www.postgresql.org/docs/17/datatype-character.html Hi. What would be the best online doc to learn about the p

Re: Postgres do not support tinyint?

2025-01-10 Thread Vladlen Popolitov
Igor Korot писал(а) 2025-01-09 02:40: Hi, Christopphe, On Wed, Jan 8, 2025 at 1:34 PM Christophe Pettus wrote: > On Jan 8, 2025, at 11:30, Igor Korot wrote: > There is no boolean - it is 0-4 inclusive. Unless you have somehow gotten PostgreSQL running on an IBM 7070, the range 0-4 can b

Re: Parameter - shared_memory_size

2025-01-10 Thread Laurenz Albe
On Fri, 2025-01-10 at 12:14 +0530, Jayadevan M wrote: > I am trying to understand the parameter shared_memory_size. It is a static > parameter > that reports the size of the shared memory area. Does that imply that the > value may > change depending on the memory used by the server? No, that val