- Postgres Rocks
- :
- About neiljo10
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
About neiljo10
since
2 weeks ago
Monday
neiljo10
Level 2 Adventurer
8
Posts
0
Kudos
0
Solutions
a week ago
Hi, It is actually working fine. But what I wanna confirmis that wether the data getting stored in BYTEA column is being converted to BYTEA data type. @kapil @Ranjan
... View more
a week ago
Hello, I want my code function to convert the JSON data to BYTEA and then inserts into the table. Following is the code, CREATE OR REPLACE FUNCTION INS_BLOB() RETURNS VOID AS $$
DECLARE
v1 "TBL1"."COL1"%TYPE;
v2 "TBL1"."COL2"%TYPE;
BEGIN
v1 := utl_raw.cast_to_raw('{
"APPLICATION": {
"MEMORY": {
"OPTIONS" :{
"SOMETHING" : "SOMETHING",
"format" : "SOMETHING",
"System" : "",
"IP" : "",
"Port" : "",
"template" : "",
"Path" : "" ,
"Name" : "QUEUE",
"URL" : ""
}');
v2 := utl_raw.cast_to_raw('{
"APPLICATION": {
"MEMORY": {
"OPTIONS" :{
"SOMETHING" : "SOMETHING",
"format" : "SOMETHING",
"System" : "",
"IP" : "",
"Port" : "",
"template" : "",
"Path" : "" ,
"Name" : "QUEUE",
"URL" : ""
}');
INSERT INTO "TBL1" ("SN","COL1","COL2") values(1,v1, v2);
END;
$$
LANGUAGE 'plpgsql';
COMMIT;
... View more
Labels:
2 weeks ago
Hi @slonkar We are creating an index for a BYTEA column. When asked the same question on stack exchange, one person emphasized on the fact that an LOB column cannot be indexed. Is it true ?
... View more
2 weeks ago
Hi @slonkar In Oracle the query is something like, alter table TBL1 move lob (BLOB column) store as (tablespace TBSP1); I hope I am correct when stating that this command is moving a table's column to a tablespace. I want something like this to happen in PostGres, is there any query or method to do it ?
... View more
2 weeks ago
So does the appending happens automatically or any command is required for it ? Is there any size limit to a database or table ? Is there anyway we can extend this limit from 1GB ? @slonkar
... View more
2 weeks ago
Hi, I am moving my DB from Oracle to Postgres. In one of the query I encountered that it is using ctxsys indextype. I want to know what ctxsys actually is and is there any solutions in Postgres ?
... View more
Labels:
2 weeks ago
Hi, Is it feasible to move columns to a tablespace ? We generally move the LOB columns to a different tablespace. What are your thoughts on it ?
... View more
2 weeks ago
I am new to PostgreSQL and wish to know how the datafiles are managed and how do they append more files when a file hits limit.
... View more
- Tags:
- datafile
- postgresql11
.png "EDB Team Member"){kind=icon}
