• Importing CSV file into PostgreSQL table

    Is there a way for me to import CSV file into my PostgreSQL table? Is there a stored procedure to do this? Thanks so much for your help!

    ITKE828,720 pointsBadges:
  • COPY command for importing CSV file into PostgreSQL

    To import my CSV file into my PostgreSQL database, I'm trying to use the COPY command. But here's my question: Does anyone know if I have to have the CSV file in a specific location (where it's stored) or could it just be anywhere? Appreciate the help.

    ITKE828,720 pointsBadges:
  • Loading CSV file into PostgreSQL table

    I have a CSV file that's set up like this: value1|value2|value2.... How would I be able to load these into my PostgreSQL table? Appreciate the help.

    ITKE828,720 pointsBadges:
  • Allowing remote access to PostgreSQL database

    We have PostgreSQL and Windows 7 installed on my machine, followed by having Windows XP on our department's virtual machine. Would there to connect these databases? Also - would about allowing remote access so we can edit the database from each machine? Thank you.

    ITKE828,720 pointsBadges:
  • Oracle In Linux

    How can I able to get and work with Oracle in Linux platform. I am using RedHat Linux 9.0.

    Samachar0 pointsBadges:
  • Exporting PostgreSQL database schema to XML format

    How can I go about exporting my PostgreSQL database schema to an XML format? Is there a certain code I have to use or a tool? Thank you.

    ITKE828,720 pointsBadges:
  • How to view PostgreSQL dump files

    I have to go through a ton of PostgreSQL dump files (this is for their data). Do I have to recover each file one-by-one? Or is there an easy SQL query to see them all? Thanks.

    ITKE828,720 pointsBadges:
  • Convert MySQL syntax to PostgreSQL

    Does anyone know if there's a tool that can help me convert a MySQL syntax to PostgreSQL? Would mysqldump be an option for me? Thank you.

    ITKE828,720 pointsBadges:
  • Connection limit on PostgreSQL database

    On our PostgreSQL database, my partner and I need to find out if a connection limit has been set on a per user basis. We figured out how to set the limit. Now we just need to know if such a limit was set. Thank you.

    ITKE828,720 pointsBadges:
  • Copy PostgreSQL database or schema

    Does anyone know if it's possible to create an actual copy of a PostgreSQL database? Or even the schema? We're looking to do some testing on a particular schema (which has a lot of updates) and we need to copy it because we want to compare it to the original.

    ITKE828,720 pointsBadges:
  • PostgreSQL to SQL Server database migration

    Our department has a PostgreSQL database that we need to move over to SQL Server. That includes both the schema and all the data. It's becoming a very slow process manually and we need something automatically. What should we do here? We're currently moving over the tables one-by-one.

    ITKE828,720 pointsBadges:
  • What queries are running on my PostgreSQL database?

    I'm running a PostgreSQL database and one of my applications runs queries on it. Is there a way I can see which queries are running on it? The computer I'm running it on is a Linux.

    ITKE828,720 pointsBadges:
  • PostgreSQL to MySQL data migration

    I recently changed my database from PostgreSQL to MySQL. But how can I do a data migration from one to the other? Is there a certain command to migrate the database data?

    ITKE828,720 pointsBadges:
  • PostgreSQL error when creating extension: No such file or directory

    When I'm trying to create my extension in PostgreSQL, I keep getting this error message: Could not open extension control file. No such file or directory. How can I fix that? Thanks.

    ITKE828,720 pointsBadges:
  • What is PostgreSQL

    What does PostgreSQL stand for?

    Ulrichetile5 pointsBadges:
  • What’s the best method for PostgreSQL incremental backup?

    We've been using pg_dump piped to gzip to split for PostgreSQL backups. But here's the problem: All of the output files are always changed (so basically the checksum-backup copies all of the data). Is there any other way to perform an incremental backup of a PostgreSQL database?

    ITKE828,720 pointsBadges:
  • Web project setup

    I am new the Linux servers but will be using CentOS servers. I have a web application that was created in Java using a NoSQL database. This application will give users the ability to create there own drag and drop web sites. Very similar to , Web.com, wixs.com, suarespace.com and weekly.com. We...

    sstepky60 pointsBadges:
  • MySQL or PostgreSQL for block storage volume

    I was wondering if I could have 2 VP MySQL servers and one SQL database located on a block storage volume. Then I can mount the same volume on both servers reading and writing to a singe database so I can have two VP MySQL machines access and running one database. Thanks

    sstepky60 pointsBadges:
  • How can I reset a sequence in Oracle?

    Hello, Does anyone happen to know if I could reset a sequence in Oracle? I understand how to do it in PostgreSQL: ALTER SEQUENCE serial RESTART WITH 0; Thank you very much!

    ITKE828,720 pointsBadges:
  • Where is the data directory located in PostgreSQL?

    I just started using PostgreSQL again but I have forgotten several things. Particularly, where is the data directory located? I tried using /usr/local/postgres/ but it still doesn't exist. Thanks for the help.

    ITKE828,720 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following