View Full Version : postgresql answers


Pages : 1 [2] 3 4 5 6 7 8 9 10 11

  1. How to enable PITR on all POSTGRES server
  2. Batch file + psql problem
  3. getting started with v 7.4
  4. how to append the string to SQL queries in stored procedure of Postgres....
  5. Creation and modification timestamp
  6. to change datatype
  7. Problem in converting float4 type to float8
  8. postgreSQl chennai trainingc enter
  9. returning columns from different tables, in plpgsql function
  10. Names of columns with foreign keys
  11. Error: relation with OID 22938 does not exist
  12. how to qeuey this in paadmin like mssql
  13. Can you use a stored procedure in a subquery in postgres?
  14. Installation fails
  15. Encoding problem in create database
  16. Address already in Use, postgres doesnot restart
  17. Restoring the dump in a new database does not contain oids
  18. Selection in pgsql using dynamic tables.
  19. Table Creation Problem
  20. Connecting to PostgreSQL using VB.NET
  21. BYTEA convertion to TEXT
  22. PostgreSQL Tablespace Creation Problem
  23. doubt in CASE command
  24. Can I connect to remote DB using psql?
  25. Installation Problems with Windows XP
  26. return type of function wen having different datatypes
  27. round to the nearest integer
  28. Is there a PHP cursor?
  29. Bitemporal tables sequenced unique triggers
  30. postgresql
  31. syntax to view the structure of a table using sql
  32. Running ACT! 2008 Database on two Laptops
  33. getting tuples of result
  34. how to configure Pgpool-II to replicate postgres database in linux
  35. Restore from plain text
  36. Problem in executing sql file
  37. trigger problem
  38. double quotes inside single quotes => ' " ... " '
  39. How to show time stamp in postgres pg_log/TodaysFile
  40. plperl problem
  41. How to setup a Arabic compatable Postgres DB
  42. postgreSQL user permission denied
  43. Postgresql database connection error...
  44. doubt in update query inside a function
  45. CREATE LANGUAGE cannot load library
  46. Need help with a slow UPDATE query
  47. PostgreSQL logical storage
  48. pg_restore in C - language how to...
  49. Physical files
  50. Problem in Select Query
  51. PostgresSQL server connectiong problem with C-language...
  52. Transactions
  53. converting POINT(-43.16 -0.876) to Latitude and Longitude
  54. doubt in exporting a file into database
  55. datamodel
  56. executing a query daily
  57. Error in following query
  58. PG archiver problem
  59. PostgreSQL dump restore from client
  60. Online replication of Postgresql databases
  61. Performance Tuning
  62. Postgresql Reinstallation problem on Windows
  63. problem in using unicode datatype
  64. current transaction is aborted. queries ignored until end of the transaction block
  65. Problem regarding a function
  66. install postgre
  67. install postgre
  68. why did not suppert Rollback? postgresql
  69. doubts in slony
  70. difference
  71. PostScript Reports
  72. stupid misstake with DB encoding
  73. Query about 20,000 record problem(slow)
  74. Problems with unique key constraint.(CASE INSENSITIVE)
  75. Insert data in win1251 encoding to base with utf8 encoding
  76. Problem inserting into a view
  77. Updating a coloumn value by comparing coloumns from two tables
  78. Top Value in a Table
  79. PostgreSQL equivalent to MySQL LOCATE()
  80. pg_dump backup doesnt restore everything - things missing... restore howto required
  81. Using the result of a function that RETURNS SETOF
  82. Closing a database
  83. doubt regarding rollback
  84. database connection problem
  85. logically-delete a row rather than actually remove in from table in postgreSQL
  86. Restore after server crash
  87. Add not null column in a table
  88. Rules in Postgresql
  89. FATAL: role "root" does not exist
  90. postres triggers
  91. Problem: Retrieving Records based on the From & To Date
  92. doubt in arrays used in function
  93. PostgreSql Documents
  94. how to move the data ,because of the partition table
  95. doubt in function
  96. MySQL and PostgreSQL
  97. Reading into FoxPro via psqlODBC
  98. how can we use partition table ?
  99. Combining two fields data into one field in the same table
  100. Need Help In Postgres
  101. COPY Query fails in postgre release 8.2
  102. how can i use the initdb?
  103. Optimal architecture for a postgres DB?
  104. Open Source Application Server (PostgreSQL Perspective)
  105. function in postgreSql
  106. How to speed up a query
  107. Cannot change column data type
  108. query the results of a table function applied to all the rows of a different table
  109. Project On Postgresql
  110. Duplicate a DB
  111. how to retrieve number of fields in the table
  112. Installation Issues
  113. Lock Problem
  114. How to create Function for executing query ....
  115. DISTINCT or GROUP BY don't seem to help
  116. Multiple Group by
  117. ERROR : relation "master"
  118. Error while running createdb from a batch file in windows xp
  119. Are queries different between sql and postgresql?
  120. Integer array in where clause
  121. copy command
  122. Partitioning database in Postgres
  123. how to get column names of a table
  124. copy command
  125. Using cursor for update
  126. Enterprise Wide Deployment
  127. syntax for copy command
  128. Benchmarking tools for PostgreSQL on Linux (fedora)
  129. ERROR: return type mismatch in function returning tuple
  130. ERROR: SELECT query has no destination for result data;
  131. inserting data in time field
  132. Get the generated value of serial type field (primary key)
  133. Slony-I questions
  134. Select For Update
  135. Function To Return Insert Statements In Postgres
  136. Extract date from timestamp
  137. Exporting data from postgresql to oracle
  138. Is there separate package for client and server in postgresql
  139. Server - Client Application
  140. doubt in a datatype
  141. syntax to view the structure of a table
  142. Is Pg replication used for multi master or two master asynnchronus replication
  143. explain
  144. ERROR: column "nr_first_name" of relation "gistl_new_request" does not exist
  145. Cant view table description
  146. PGCluster-II version 1.3 implementation
  147. Error:: 'more' is not recognized as an internal or external command
  148. What replication are people using
  149. Import data into Postgresql
  150. how to post to the forum
  151. Understanding End of Cursor?
  152. A far cry - but here's hoping - PostgreSQL Replicator
  153. Too many clients already
  154. Installation of PostgreSQL on Windows XP
  155. Help with Tags database design.
  156. retrieve two tables in a single query
  157. Returning SETOF in plpgsql
  158. oid problem
  159. How to add a column to the table
  160. Convert data from char type to byte tape
  161. Stored functions
  162. Mapping select results through a function
  163. Stored functions books
  164. I couldn't install 8.2 ( Instead of I got a lot of Error messages :)
  165. alias name inside the function
  166. What is the output statement in PostgreSQL
  167. Regarding Installation of postgresql as a client - server
  168. syntax error at or near "TYPE"
  169. Postgresql supports Map Info's Easy Loader and MapXtreme-- Java
  170. Hybrid Environment
  171. Too Many Client Connections -- Error -- Need Help
  172. Hello everyone, I am new to this site and SQL server
  173. Building an aggregate function
  174. "is not scalar Variable" Error
  175. scripts for converting dbf or mdb files to postgres
  176. array parameter in plpgsql function
  177. Keeping two db's in synch across continents
  178. order by for varchar datatype column with numeric values
  179. Functiion Problem
  180. starting psql in windows
  181. Postgres backup and restore
  182. PostgreSQL Database Backup at System Shutdown time in OS Windows XP
  183. shp2pgsql Help with syntax
  184. pg_restore is not recognizing dump
  185. maximum function
  186. What is commit_delay & commit_siblings?
  187. Problem with function
  188. Start of Year
  189. migration tool
  190. All About - PostgreSql
  191. PostgreSQL and OleDb
  192. Need help with triggers
  193. using ILIKE xyz where xyz is a function parameter
  194. Pgsql 8.4 on Vista starts and stops automatically.
  195. bulk copy from flat file to postgres dbserver
  196. output parameters in functions
  197. Postgres 7.x and Legato backup
  198. Postgres8.1 Database Server could not be started
  199. How to store binary files in the PostgreSql database table?
  200. How PostgreSQL searching Queries?
  201. Constraints vs Indexes
  202. Create function question...
  203. Transaction Problem
  204. Improving date(timestamp) searches
  205. crystal report
  206. How to set TG_ARGV values
  207. USE OF VARIABLES IN postgreSQL
  208. How to replace characters in dblink
  209. getting latest filled row
  210. problem with date
  211. How to get column name
  212. Auto mail sending using postgresql
  213. syntax is not supported error
  214. need an sql query for the following situation
  215. Copy Table to other database
  216. Cannot compile plpgsql function
  217. pg_dump Failure
  218. Aggregate/concatenate function (flattening columns into a row)
  219. Temporary tables
  220. User and Role
  221. How to copy data from one table to other table
  222. Function declaration for MSFTSql developer
  223. function execution
  224. using array data type
  225. What would my SQL statement look like?
  226. Database connection problem
  227. Error Installing PostgreSQL 8.1.9 on XP
  228. no lock
  229. unsorted column
  230. how to convert a query from SQL to HQL(hibernate Query Language)
  231. Beginning with PostgreSQL
  232. How to configure static ip PostgresSQL 8.1 for windows XP system
  233. How to find out that SSL is activated
  234. Postgresql 8.2 connection problem on static ip
  235. Stored Procedures in PostgreSQL
  236. execute funtions in psql
  237. SUM with possible NULL values
  238. Connecting to PostgreSQL through SSH (putty)
  239. Exporting tables from Postgres to SQL
  240. Installation of PostgreSQL 8.0 on Solaris10
  241. Stored procedure
  242. problem in querry
  243. Adding new column to existing table
  244. Support for ROWNUM and ROWID
  245. Size of table and size of database
  246. Use Of Dblink
  247. how to export postgresql tables
  248. psql won't connect, though other clients are OK
  249. Serverless/embedded PostgreSQL database
  250. Date difference
  251. count months between two dates
  252. 24 hour time format
  253. Substract hour into a function
  254. import Excel to postgreSQL
  255. Retrieve number of rows in table
  256. Invoking psql at command prompt
  257. Migration from SQL Server to PostgreSQL
  258. How to recover the deleted fields with values from bakup.
  259. recovering fields in tables
  260. Postgres Violates Primary key and OID
  261. hai i am new here.i have question,please give me reply as soon as possible
  262. Function returning setof
  263. PostreSql function
  264. Migrating IBM Universe Database to Postgres, date format Problem
  265. Run Unix Shell Scripts With Postgres Trigger
  266. server closed the connection unexpectedly
  267. getting current date
  268. For Report Generate
  269. Usisng PQgetvalue
  270. Database Design Help
  271. Need help with query involving automatically decaying values
  272. psql copy
  273. Getting Parse Error at or near and at character......
  274. Variable column name
  275. Transfer of Data from Oracle to PostgreSQL
  276. create database if not exists
  277. data fetch and insert
  278. Oid
  279. Foreign key problem
  280. How to assign a primary key
  281. pg_restore doesn't work for postgresql 7.2.3
  282. How To Execue Queris Fastly
  283. Posting Guidelines. Please read before you post in a forum!
  284. Inheritance Problem
  285. Help : what this Error means
  286. Installing PostgreSQL 8.1 on VISTA
  287. load balancing
  288. how retrive this problem
  289. Problem in function with CREATE ROLE with parameters
  290. BackUp and Restore PostGreSQL8.1
  291. HOW TO exit from a query
  292. controlling postgres I/O and CPU processing
  293. performance tuning postgres 8.2.3 on windows with shared server applications
  294. Retrieving values from tables
  295. stored procedure in postgresql
  296. Problem with Windows PostgreSQL 8.1 service
  297. download old version of PG
  298. restore problem
  299. how to compare two tables
  300. what is the keyWord DELETING
  301. Strange result using transactions
  302. How to Upgrade Postgres 7.x.x in RH9 to new Postgres version 8.x.x ??
  303. Postgresql installation problem??
  304. php objects in postgresql
  305. odbc call failed
  306. Starting More Than one Transaction
  307. Fatal error: Call to undefined function pg_connect()
  308. Connection Exception
  309. joins
  310. How to know the Number of Connection made with the database
  311. how to write the select query for this situation
  312. C# .NET ===> postgreSQL
  313. Pagination in Postgre
  314. If criteria is Null then show all.
  315. Test Suite for Postgresql
  316. How can I display the stored image?
  317. Storing files in Postgresql database
  318. Interface to posgresql
  319. How to check a query execution plans in PostgreSQL
  320. HOW TO merge two strings
  321. need copy table sql example in postgres
  322. use of client-side \lo_import and \lo_export commands
  323. Server doesn't listen
  324. SHA function?
  325. Fastly Inserting Records
  326. how to release locks when instance crashes
  327. HOW TO Use transaction control statements inside a sored procedure
  328. Back Up And Restore
  329. Functions and Commits
  330. how to write this sql statement
  331. Nested use of found doesn't seem to be working
  332. Alter table doubt
  333. Driver for postgresql
  334. Redundant data in postgres
  335. Migrating data between dbs with different schemas
  336. Postgres Newbie - Case Problems in queries
  337. Multi dimensional arrays, sub selects...
  338. Error When creating the table
  339. String was not recognized as a Valid Date Time
  340. Postmaster is accepting TCP/IP connections error
  341. Data Migration From Excel to PostgreSQL
  342. date queries with portions of the date unknown
  343. How to Fix Corrupt Tables
  344. Unable to connect
  345. Postgresql Compression Across Network
  346. limit database size
  347. limit database size
  348. query and subquery in python
  349. retrieve column array values
  350. how to execute script from file within function
  351. retreive values from an array into column
  352. Can PostgreSQL initiate a message through a socket?
  353. how to insert image
  354. which is the best interface for postgresql
  355. unable to set 'Owner' column to different role
  356. username
  357. inserting values into array column
  358. Query regarding odbc connection ??
  359. how to give login in a table
  360. limitation of postgresql
  361. how can I fetch data from the database and display it in form of a editable html form
  362. ALIAS error
  363. postgis function
  364. FATAL ERROR on Solaris 10
  365. postgresql function
  366. invert an array
  367. postgresql installation fails on windows 2000
  368. accessing last element of an array
  369. How to cast varchar into timestamp in postgres
  370. How to make a copy of data in RAM ???
  371. update multiple cols in trigger
  372. How to make cross-database reference in Postgres
  373. nesting joins
  374. How to insert multiple sub columns inside a column ??
  375. on delete set null problem
  376. Databinding bool fields
  377. Increase the Cache Size
  378. Query regarding SQL commands ?
  379. how to make a Postgre DB setup on windows
  380. PL/PGSQL function
  381. getting the last record using timestamp
  382. create database test if not exists
  383. Writing DDLs in Functions
  384. Writing DDLs in Functions
  385. Postgre Sql on Solaris operating system
  386. urgent help!!
  387. Sum of “sales” for each date in a timestamp column
  388. How to know that a schema exist?
  389. Web Development Team Needed - Prefer Croatian or Eastern Europeanbased
  390. PHP Postgresql "All-In-One" CRUD Needed
  391. need help
  392. a problem when I create a trigger procedure.
  393. Postgres on XP / ODBC setup / Visual C++ API
  394. Transaction Logging Mechanism
  395. SQL question??
  396. TCP/IP Connection Error
  397. The MySQL command LEFT() counterpart in PostgreSQL?
  398. Exception Handling
  399. current transaction aborted
  400. SQL problem, help if possible please.
  401. How can I support multimedia with postgres?
  402. Postgres Connection Error
  403. HI all
  404. Restoring dump files completely
  405. PostgreSQL - JDBC2 lose connectivity after a while
  406. hi all
  407. .NET Questions
  408. postgresql module
  409. Copy / Paste in PostgreSQL from remote server.
  410. postgresql installation
  411. functions in postgresql!!!
  412. select distinct with datatype point
  413. an urgent question
  414. data conversion
  415. select-where anomaly
  416. Migration od Database
  417. installation error
  418. inserting values in relational main tables
  419. Hash index creation problem
  420. How can we manage PK and FK using inheritance??
  421. Are Primary Keys Necessary for Linking Tables?
  422. filename extension postgreSQL
  423. DBF to Postgres using DBF2PG
  424. Bulk Extract and Load data in PostgreSQL
  425. error in logs file
  426. To insert 60million rows to database
  427. can't get the full results from postgresql
  428. What is ODBC Query timeout error
  429. How to configure postgres for max disk space usage
  430. web interface library/classes
  431. Sql Case Statement
  432. Problem with executing Postgres function from javacode
  433. pg_clog errors
  434. table creation
  435. Postgres and ESQL
  436. Postgresql Vs. Mysql -- Need advice
  437. How to write postgres query with time comparison ?
  438. Hey i need advice!
  439. Subjectre31
  440. Reg Postgres Sql Replication Concept
  441. Reg Postgres Sql Database Instal On Windows 2000
  442. Syntax error doesn't make sense...
  443. just some info you might be intersted
  444. Tickets
  445. Create UNIQUE KEY
  446. Reg AutoVacuum
  447. Garbage Collection with Custom Session Handlers?
  448. Performance problem with joins
  449. plpgsql FOUND unexpected behaviour
  450. Need Clarification About Replication Concept In Postgres Sql
  451. How to convert from sql to postgresql (stored procedure)
  452. 7.4.13 LANG=C, order by still wrong
  453. Recieving notification when a table changes
  454. Limitation in query result from postgresql table
  455. date format in postgresql database
  456. libpqdll.lib
  457. Help with Database Solution
  458. Linking Tables from 2 databases
  459. Ora2PG exporter and UTF Characters
  460. alternative to distinct on?
  461. How to Use "If Exists" in PgSql
  462. Postgresql Stored procedures
  463. Postgresql
  464. Money datatype?
  465. Performance Issues PostgreSQL on Solaris
  466. Two general, simple questions
  467. Postmaster Problem
  468. What architecture for a Large Database with PostgreSQL
  469. XP Embedded and Postgres No Happy Campers
  470. Fedora Core 4 & PostgreSQL
  471. xml export tool?
  472. Dual servers
  473. Python x Postgresql Thrreading Problem
  474. Outer Join on 3 tables
  475. Conditional delete
  476. Timestamp not working
  477. is there a function which elminates spaces?
  478. OLAPy stuff crawling a bit
  479. async queries (libpq)
  480. Looks to me like MySQL has a change coming
  481. Generate/Manage a PostgresSQL database using Visio?
  482. PostgreSQL Linked server question with MSSQL2K
  483. Urgent: Input of values to execute dynamic queries
  484. 1991 and 1992 Black Box Catalogs
  485. Happy Fish Database Designer
  486. Need Database person
  487. Need Database person
  488. encoding question
  489. Where can I download HTML manual?
  490. linking access using ODBC driver with geometric data
  491. Good Portal for data mining resources
  492. Tablespace layout question
  493. scroll cursor bug or me?
  494. SQL Profiler
  495. How to copy a PG database
  496. ordering text field with non-alphanumerical character
  497. crosstab error 'query-specified return row and actual function return do not...
  498. Statement-level Triggers
  499. DateAdd function ?
  500. views, functions and parameters...
  501. ADO and PostgreSQL functions
  502. How to return a record and sets of record in plpython
  503. Great News Blog!
  504. Query Optimizer Failure / Possible Bug
  505. Bitwise operators for bytea
  506. can't update bytea field with function
  507. resultset to xml
  508. Tsearch index not set by UPDATE in PgSQL 7.3.2
  509. function no return
  510. Installing PostgreSQL 8 on Debian
  511. how to run function?
  512. SQLDescribecol in driver 8.00.0100
  513. Postgresql 8.0-beta2-dev3 on Windows 2000
  514. Adding pgAdminIII Server - Passwords?
  515. Good page with Oracle x PostgreSQL comparsion
  516. PostgreSQL and XML
  517. Danish users
  518. simple query runs very slowly
  519. using OLD variable in DELETE trigger
  520. Please Help with libpq and unicode
  521. eval function?
  522. Postgres+XML
  523. SQL Query
  524. libpq location?
  525. pgsql user account in pgadmin doesn't need password
  526. SuSE Linux and PostgreSQL
  527. What is future of partitioning?
  528. PostgreSQL/PHP/UTF-8?
  529. Oid Type
  530. The second RFD is in news.groups.
  531. Table name as parameter in function
  532. Upcoming Changes to News Server ...
  533. I need to add a column to a table
  534. Will B4->B5 require an Initdb?
  535. Lexical question...
  536. Bug in queries ??
  537. PostgreSQL 8.0.0 Beta 5 Now Available
  538. null value of type java.sql.Time
  539. primary key and the default index operator class
  540. Postgres-Windows -Perl DBI
  541. Foriegn Keys?
  542. SELECT duplicates in a table
  543. Storing every scrabble board possible
  544. Help with syntax for timestamp addition
  545. null value of type java.sql.Time
  546. Oid to text...
  547. Unions, schemas, and design questions...
  548. timestamp with time zone question...
  549. COMMIT within function?
  550. Any good report/form generators for postgresql?