Search DaniWeb - postgres

Using Natural Language to Query SQL Databases with Python LangChain Module 2 Months Ago by usmanmalik57 … the connection string is as follows: ``` f"postgresql+psycopg2://postgres:<<password>>@<<server>>… employees with the highest sales. ``` postgres_uri = f"postgresql+psycopg2://postgres:mani123@localhost:5432/northwind" pg_db = SQLDatabase.from_uri(postgres_uri) query… Re: Using Natural Language to Query SQL Databases with Python LangChain Module 1 Month Ago by aishamushtaq very helpful Postgres database backup........... 14 Years Ago by nikhilmohan …/restore my database file by using jsp code??? im using postgres sql... please its urgnt..tnx in adv. i am using…("pg_dump -h org.postgresql.Driver -U postgres -W EmplDir_MySQL> db.20070725.dump Password:postgres"); InputStreamReader irs = new InputStreamReader(child… Postgres ownership rules? 17 Years Ago by EnderX Does anyone know how to change the ownership of a view in a postgres database? I have no clue how to do so, and all of the solutions I've seen so far online don't want to work for me. Thanks in advance, -EnderX Re: Postgres ownership rules? 17 Years Ago by pty [QUOTE=EnderX;257218]Does anyone know how to change the ownership of a view in a postgres database? I have no clue how to do so, and all of the solutions I've seen so far online don't want to work for me. Thanks in advance, -EnderX[/QUOTE] [code] ALTER TABLE vw_my_view OWNER TO pty; [/code] Postgres digest func inside procedure works on pgadmin but not in Laravel 5 Years Ago by azegurb Hi there, recently I have created stored procedure in **Postgres Sql** which deals about with hashing passwords. When used via **… Distributed database with Postgres 16 Years Ago by fvillavi Hi: I am trying to implement a distributed database application with Postgres similar to one that I've in Oracle. I can't find an equivalent Oracle DATABASE LINK in Postgres. Does any one know how to connect two remote sites in Postgres? Thank You. [email]fvillavi@yahoo.com[/email] jsp postgres error 13 Years Ago by ankurmawanda … having some connectivvity issues i am using postgres 9.0 sql db i have installed …a dns localhost using the postgres sql driver also i have the jdbc jar…DriverManager.getConnection("jdbc:postgresql://localhost:5432/sample", "postgres", "ankur"); Statement stmt = conn.createStatement… Re: jsp postgres error 13 Years Ago by ankurmawanda … [CODE] <HTML> <Head><title>postgres connection check</title></Head> <BODY… = DriverManager.getConnection("jdbc:postgresql://localhost:5432/sample", "postgres", "ankur"); Statement stmt = conn.createStatement(); ResultSet rs… Re: jsp postgres error 13 Years Ago by ankurmawanda …= "jdbc:postgresql://localhost:5432/sample", user="postgres", passwd="ankur"; Class.forName ("org.postgresql…= DriverManager.getConnection("jdbc:postgresql://localhost:5432/sample", "postgres", "ankur"); Statement myStatement = myConn.createStatement (); String… .htaccess & Postgres 18 Years Ago by Mareq … can not find libapache2_mod_auth_pgsql. Only modules I found was libapache_mod_auth_pgsql (Postgres authentification Apache module for Apache version 1, not 2) and… MySQL database instead of Posgre SQL). I tried to install Postgres authentification module for Apache 1, but dselect told me (as… Reg Postgres Sql Replication Concept 17 Years Ago by sivapri Hi every body.This is siva from china.My s/w using postgres sql data base.Hw to use replication concept in postgres sql>if any body knows pls reply me.Advance thks su - postgres within shell script 16 Years Ago by toronto … learning quickly. My script looks as follows: #!/bin/sh su - postgres echo "Please enter the password for a2billing user and… database. However, my output stops after using command "su - postgres". What can I do to curb this? is there… Re: su - postgres within shell script 16 Years Ago by eggi … to enter 3 passwords (assuming you're not su-ing postgres as root) - one for the su - one for the createuser… and one for the createdb call) su - postgres -c "echo "Please enter the password for a2billing… postgresql and pgAdmin3 "FATAL: database "postgres" does not exist " 13 Years Ago by lonelyday … with this name: test host: localhost port: 5432 Mantainance DB: postgres Username: test the rest i left it empty. but i… has occurred: Error connecting to the server: FATAL: database "postgres" does not exist[/QUOTE] hope someone can help me… JS array to postgres 12 Years Ago by FreePuppy … video into segments. I want to save those cuts in postgres but I heard js is not safe to insert into… do to get an array in JS to store in postgres? [ICODE]<html> <head> <title>… Assigning "Usage" DB Permissions, Postgres 7 Months Ago by cored0mp … I should switch back to Mysql? It seems like with postgres there are a lot of hoops to jump through but…'s what everyone else is doing. No point in using Postgres if it's a step backwards. Thanks in advance! Re: su - postgres within shell script 16 Years Ago by masijade Because su opens an interactive shell you might try placing everything below the su command into a seperate script (lets imagine we call it newScript.ksh), then change this script to the following: [code] #!/bin/sh su - postgres -c "/path/to/newScript.ksh" [/code] Re: su - postgres within shell script 16 Years Ago by masijade … -r -e a2billinguser createdb -e -O a2billinguser a2billing EOF su - postgres -c "/tmp/someObscureName.sh" rm -f /tmp/someObscureName… Re: Assigning "Usage" DB Permissions, Postgres 7 Months Ago by rproffitt … power to all possible users. 3. The old MySQL vs Postgres question seems to be about if your needs are read… Checking Postgres installation options 17 Years Ago by EnderX I've been requested to upgrade a postgres system running version 7.4.9 to one running version … PHP & Postgres pagination 16 Years Ago by chrisw09 … seconds to finish. While digging through the PHP functions for postgres, i came across the fact that you can pass an… Re: PHP & Postgres pagination 16 Years Ago by petr.pavel … you may be better of by running the query twice. Postgres caches a lot of things so running the query for… selecting on bit value in Postgres 14 Years Ago by kireol Pardon this post here as I didn't see any Postgres forum. I have a table with a 16 length bit … how to connect to postgres database 13 Years Ago by newuser17 I want to store data that user inputs [form based in form of xml] into a postgres database, so I would like to know is it wise to develop a web service or how do I transfer data. I am completely clueless how to head on with the problem moblile postgres form 13 Years Ago by ankurmawanda i am creating a midp 2.0 s40 mobile application s40 that will post some data in to a postgres sql server i have created a form with text boxes and selection list can some one please tell me a way how do i post an sql query i have the ip adress username and password for the server thanks in advance please reply Connection between Postgres and Java 12 Years Ago by George_91 I'm trying to connect a DB from Postgres with a program in Java. I'm including this code: … create a database-specific table in postgres? 7 Months Ago by cored0mp How do I create a table in postgres that's associated with a specific database? Obviously from the … Re: create a database-specific table in postgres? 7 Months Ago by cored0mp … installation script must first connect to the database as the postgres user in order to create the databases. What got this… Re: Postgres database backup........... 14 Years Ago by nikhilmohan still anyone hav no idea!!!!!!!!!!!!!!!!!!!!!??????