On Sat, 2024-03-16 at 14:14 +0300, PetSerAl wrote:
> I have following script, which initialize two clusters:
>
> echo CREATE ROLE new_user WITH LOGIN;>init_cluster.sql
> echo CREATE DATABASE new_database WITH OWNER = new_user;>>init_cluster.sql
> initdb -D case1 -U postgres
> pg_ctl start -D
I have following script, which initialize two clusters:
echo CREATE ROLE new_user WITH LOGIN;>init_cluster.sql
echo CREATE DATABASE new_database WITH OWNER = new_user;>>init_cluster.sql
initdb -D case1 -U postgres
pg_ctl start -D case1 -w
psql "host=localhost dbname=postgres user=postgres"OIDs
On 3/18/24 00:05, Rajesh S wrote:
Thank you for your response. Actually, I was trying to address the
following query.
select LIEN_AC_NO from deposit_lien where deposit_no='0002114029832' and
deposit_sub_no='1' and unlien_dt is null and unlien_remarks is null;
In the above query
The order of the arguments matter. You need an operator that expects a
varchar on the left hand side of the operator, and numeric on the right
side. For example:
create database cast_test;
\c cast_test
You are now connected to database "cast_test" as user "greg".
cast_test=# create table
Hello,
I need to find a fdw to access, and modify (insert and update, and delete)
ldap data. (postgres v15 on x86 redhat 8.5)
the main fdw page, in postgres doc shows 2.
1 via github seems to be old (postgres 9.2) and not maintained.
2 the second is a multicorn thing.
Or try to build something
Thank you for your response. Actually, I was trying to address the
following query.
select LIEN_AC_NO from deposit_lien where deposit_no='0002114029832' and
deposit_sub_no='1' and unlien_dt is null and unlien_remarks is null;
In the above query "deposit_sub_no" column is "numeric" type and
