[postgresql] Forum Topics

More programming fun! OK this time around I'm trying to create a table with the statement, CREATE TABLE tablename ( recnumber SERIAL PRIMARY KEY, recordvalues VARCHAR ( 500 ) NOT NULL, datecreated DATE ) And it basically works, and I can add records using the dba account. However when I …

How do I create a table in postgres that's associated with a specific database? Obviously from the command line one can do Create table tablename (); But how do I make sure that the table is associated with the correct database? CREATE table dbname.tablename(); is giving me the error: ERROR: …

[functional module] WDR [Operation steps & amp; problem phenomenon] 1、gs_guc reload -N all -I all -c "enable_wdr_snapshot=on" 2、select create_wdr_snapshot(); 3、select * from snapshot.snapshot; [Screenshot information] openGauss=# select name,setting from pg_settings where name like '%wdr%'; name | setting -----------------------------+--------- enable_wdr_snapshot | on wdr_snapshot_interval | 60 wdr_snapshot_query_timeout | 100 wdr_snapshot_retention_days | 8 …

The installed openGauss database is always wrong, prompted by the figure below：Failed to obtain the environment variable PGHOST. Traceback (most recent call last): File “gaussdb/om/script/gs_install”, line295,in <module> DefaultValue.setActionFlagFile(“gs_install”) File “gaussdb/om/script/gspylib/common/Common.py”, line 2230,in setActionFlagFile Raise Exception(ErrorCode.GAUSS_518[“GAUSS_51802”]%“PGHOST”)

In recent years, open source software, and open source community construction is more popular, such as: mysql, postgresql, and openGauss database open source communities .So, as an individual, how to specifically participate in the open source community contribution?

What is the difference between openGauss and postgresql in the key technologies?Can you elaborate on this from the following points (including but not limited to): runtime model, transaction mechanism, data storage and organization, query optimizer, etc.

What is the difference between openGauss and postgresql in the key technologies?Can you elaborate on this from the following points (including but not limited to): runtime model, transaction mechanism, data storage and organization, query optimizer, etc.

# Introduction # As we move into 2022, businesses will continue to look for ways to become more data-driven. This means that knowing how to use Structured Query Language, commonly called SQL or 'Sequel', will remain an essential skill for data scientists, analysts, and developers. In this post, we'll provide …

The web application will have a database that consists of millions (over 20mil ... maybe 100mil or more) of hosts (ipv4,ipv6 and domains) and additional data to each host like blacklist, uptime, history, geo data (country, region, city, isp). I could, of course, use other RMDBS system like MySQL, Oracle, …

Consider the following database Room (room_no,room_name,room_type,charges) Guest(Guest_code, Gname,city) The relationship is as follows: Room-Guest: one-to-one. room_type can have values as either ‘AC’ or ‘NonAC’. Q 2) A Create the above database in PostGreSQL and insert sufficient records.

Hi everyone! Do you know how to create Pizzeria Program using Python and PostgreSQL where it can keep track of the pizza orders and view the order information using Python and PostgreSQL? Technology needed: -Django for the program -Postgresql for database How it can be used: Every time there is …

Hi there, recently I have created stored procedure in **Postgres Sql** which deals about with hashing passwords. When used via **pgAdmin** tool it works like a charm as stated below. SELECT horeca_user.update_token( 1, //user_id 1, //type 'sdsfsdfs' //token ) I have also installed extension **pgcrypto**. It works when called via …

Hello everyone How to fetch data from PostgreSQL to WXpyhon GUI to automaticaly open the next processe ? Thanks

Hi there, I would love to make a list and have a collection of database servers, could you all please help me? It would be nice if you could provide a link to their homepage. If you post, I will update the first post. [list] [*]MySQL ([url="http://www.mysql.org/"]http://www.MySQL.org/[/url]) [*]PostgreSQL [*]Access [*]MSSQL …

Hello ! I have a task from my university that bothers me and I definately need some help. I have to create a web app in which i can add locations from the world map by taking the coordinates and make route between two selected locations from the added. Also …

I understand how to generate objects from the database, using Sinatra with formatting, and I understand from tutorials how to use POST to send information back, but I don't understand how to use POST to transfer information from the browser (for instance from a text field, or inside <p id="stufftotransfer"><%= …

how to fetch data from PostgreSQL to WXpyhon GUI to automaticaly open the next processe ?

I have been trying to insert,update,delete,select with separate queries.But when i try to write a query after a pre-written query i get an error that the string is predefined.I am working on a PBL project so i have to show all that in one program itself. Here is the current …

I have the query below: $insert2query="INSERT INTO output_search(ref_code, title, author, channel_id) VALUES (select refcode,title, authors, $idquery as cid from chemoJ where title LIKE '%$search%' and refcode NOT IN (select exc_refid_fk FROM exclusions))"; It is giving me an error near the parenthesis, what is wrong with my sintax? I ran the …

Hello ,I want to ask how can I succeed an analogous from mongodb to postgresql. app.post('/myjob', function(req, res) { var collection = db.collection('theDB'); collection.insert({ "my_id" : myID, .... }, function (err, mes) { if (err) { res.send("There was an error"); } else { console.log("Ok with ID "+myID); res.send({ "Done!", ID …

Dear Experts I am using windows 7 32bit. I have created database named "accounts" and 2 tables in it through pgAdmin III. The database is working well but I am unable to found it physical location on hard disk. On what path should I find it? Thanks

Hi, I am writing a code to dynamically create a table and then add delete and modify records. The table is created from an existing database table. How ever the add and the deleting of records is not wrking. I think there is some error in the query statements. Please …

Hi, I am working in a company that utilises many systems with their own databases. For example, the cafe has its own CAFE system with its own database (it could be postgresql). The Health Care system has its own database system (it could be MS SQL). The Transport booking has …

Hi, Im trying to display all the rows from a table (im running on Postgres and NetBeans 6.5). I only get one row.. my code: the actor class [code=Java] package appsClass; import java.sql.*; /* * To change this template, choose Tools | Templates * and open the template in the …

I am a newcomer to java and jdbc. I am currently trying to develop a web application in which the user can upload a spreadsheet to the form. Is there any way in which contents of the uploaded spreadsheet can be saved to the database? I am working in eclipse …

i have a table tbltrans transno | agent name | date | --------+-----------+------- 1 01 | waw |2014-10-10| 1 02 | waw |2014-10-15| 1 03 | waw |2014-10-20| 1 04 | waw |2014-10-30| i want a query for postgresql that calculate the average time for agentname the result is like …

Hi Guys I am a rookie here... I have a function which gets information from a postgres database. And returns an array. But how do I echo a single value from the array returned by the function. Please see function below: function getDate($campid) { global $conn,$agencies; $return=array( 'date'=>'', ); $sql …

Hi I am getting a **HTTP Status 500 - An exception occurred processing JSP page /registration.jsp at line 15** error. The page is a registration jsp page that submits the following parametres into the database. However there are no hints in Eclipse as to what caused the error. Can someone …

This should be an easy question. I just need to make so that when you click on some function in pgAdmin 3 and then click the SQL button on the top (the focus glass icon) the code form the selected function (showing in the sql pane) to automatically show in …

Hi All First post. PHP/PostgreSQL newbie... I'm trying to create a simple web page with a dropdown menu. The values for the dropdown menu are retrieved from a database table. The code I've got is... <html> <body> <select> <?php $db = pg_connect("host=hostname port=5432 dbname=dbname user=user password=password") or die ("Could not …

Hello Guys, Good Day. I have this kind of error `OperationalError: no such table: table_name` when I make a query like `modelname.objects.all()` in **manage.py shell**. But I already did the ff: 1. settings.py > Databases > django.db.backends.postgresql_psycopg2 DATABASES = { 'default': { 'ENGINE': 'django.db.backends.sqlite3', 'NAME': os.path.join(BASE_DIR, 'db.sqlite3'), }, 'db_foo': { …

hai.. i need to get all tables names from my database.i am using postgresql.what is the query for selecting all table names..please help me

Structures of my tables are as follow. Table Name : timetable [Image1](http://www.4shared.com/download/MYafV7-6ce/timetableTable.png) Table Name : slot_table [image2](http://www.4shared.com/download/9Lp_CBn2ba/slot_table.png) Table Name : instructor(this table is not required for this particular problem) I want to show the resultant data in my android app in a timetable format somewhat like this: [image3](http://www.4shared.com/download/oAGiUXVAba/random.png) **Question** : …

I am converting a PHP application from MySQL to PostgresSQL. The MySQL works flawlessly. The database for this application is a one to many relationship. I have a while loop nested inside another while loop <?php while ($movie_row = pg_fetch_array($movie, PGSQL_ASSOC)) { ?> [html code to echo various elements of …

Hello guys!! I have a database and I store public tweets inside. I have lots of columns, including timestamp with timezone column. For example: timestamp | tweet_id "2013-07-30 11:14:07.404+03" 6598dsf4466a "2013-07-30 11:14:08.028+03" 87f9dss99s97 ... "2013-08-04 17:36:37.924+03" 646s4f64a64 "2013-08-04 17:36:38.891+03" 654asd9f654a So, I want to make clusters (time clusters) with these …

I have a program that takes csv values, parses the content and inserts it in an sqlite3 database. I am using sqlite3 to save on space and to make the py scripts a little more portable. The next refactoring may well need to have postgresql or mysql to deal with …

I am using postgres and stackbuilder , which install postgres,apache,and php togather. Now i want to fill a square image with 4 different colors. How to do it.

Hello, I'm working with PostgreSQL and Python to obtain 2 columns froma database and need to print it in a specific format. Here is my current code. #!/usr/bin/python # -*- coding: utf-8 -*- import psycopg2 import sys con = None try: con = psycopg2.connect(database='DB', user='ME', password='1234') cur = con.cursor() cur.execute(" …

I made this code: INSERT into author(authorfirstname1, authorlastname1,authorfirstname2, authorlastname2) select '".addslashes($_POST['authorfirstname1'])."','".addslashes($_POST['authorlastname1'])."','".addslashes($_POST['authorfirstname2'])."','".addslashes($_POST['authorlastname2'])."' from author where not exists(select authorfirstname1, authorlastname1, authorfirstname2, authorlastname2 from author where author.authorfirstname1='".addslashes($_POST['authorfirstname1'])."' and author.authorlastname1='".addslashes($_POST['authorlastname1'])."' and author.authorfirstname2='".addslashes($_POST['authorfirstname2'])."' and author.authorlastname2='".addslashes($_POST['authorlastname2'])."' ); The point of this code should be that it checks, if a value allready exists in database and if …

Good day I’m new with JSP, here the problem, I just converting the code from SQL to PostgreSQL, but a problem occur after I change to DataSource ds = (DataSource)envCtx.lookup( "jdbc/postgres" ); and add a scheme to the query. By theory it should be ok but it produce this error …

SELECT getdatabaseencoding(), current_setting('client_encoding'), current_setting('lc_ctype'), current_setting('lc_collate'), version(); returns UTF8 UNICODE C C PostgreSQL 9.1.7 on x86_64-unknown-linux-gnu, compiled by gcc-4.5.real (Ubuntu/Linaro 4.5.2-8ubuntu4) 4.5.2, 64-bit select lower('ČĘĖĮ') returns ČĘĖĮ Actually what I want is to seach surnames with ILIKE which is not working for those chars. WHy this can be?

I have a CTE based query, to which I pass about 2600 4-tuple latitude/longitude values using joins - these latitude longitude 4-tuples have been ID tagged and held in a second table called coordinates. These top left and bottom right latitude / longitude values are passed into the CTE in …

Hello friends , I have two questions : 1) I was using psycopg2 for old versions of python 2.x , and now while using Python 3.3 , i can install psycopg2 , maybe it needs a special psycopg for Python 3.3 . 2) I could install py-postgresql , and i …

I am looking for a universal system that can replicate/Synronize database schemas and changed data for mysql,sql server,Oracle or atleast mysql and postgresql. Our company has different branches each with its own local data but any changes in a local database is supposed to be replicated to the central database. …

Hi, We have an Android appliation with local Postgre JDBC driver. *But there is a requirement to use a Google API with andorid application. The plan is to re-wire Android postgre DB classes to use DB from google api place. Is it possible to use Postgre SQL inside google API …

Hello guys, Please take a look at my code, coz I don't know why I cant login here in my log in form.By the way, my database is working, so the problem is in the code. looking forward for your help guys, here is my code: <?php session_start(); include("config.php"); ?> …

I inherited a website here at work. The menu system uses a convoluted jquery / javascript structure. There are 8 different types of "users" for this website, from administrator to contractor or accountant, etc, and the person made 8 different versions of the menus covering nearly 80 different pages within …

Hello, we are saving in the database time as our local time which is UTC+2 How to convert to other times? I found in that this should work: select sell_date, sell_date at time zone 'UTC+2' as UTC2 FROM cards order by id desc limit 1 This sql should return same …

I try in psql shell pg_dump --schema-only but is is doing nothing after hitting enter it just shows glab-> why is that? I tried adding ';' at the end of line - still the same. But before it there is glab=> so one char differs. Why is that? also is …