데이터베이스를 사랑하는 사람들의 모임 데이터베이스 사랑넷

Database

Community

자유게시판

도움주신분들

Admin

운영게시판

최근게시물

PostgreSQL Q&A 7601 게시물 읽기

News | Q&A | Columns | Tutorials | Devel | Files | Links

No. 7601

이많은 함수중에..
작성자	souler(souler)	작성일	2009-02-02 14:49	조회수	9,240

드디어 혼자...자습한 결과.. DB Connect 는 됩니다. 되는데, 이제 중요한 특정 테이블에 필드값을 삽입하거나, 또는 삭제 수정하는

함수를 알아야 겠는데... 하나 하나 다 해보자니 이건 무리가 있고.. 현명하게 여기에 투고 하겠습니다 !!

알려주세요. 알려주시기 쉽게 .. 메뉴얼에 나와있는 함수 다 ..

PostgreSQL 함수 목록

pg_affected_rows — 영향 받은 레코드(튜플) 수를 반환

pg_cancel_query — 비동기 질의 취소

pg_client_encoding — 클라이언트 인코딩을 얻음

pg_close — Closes a PostgreSQL connection

pg_connect — Open a PostgreSQL connection

pg_connection_busy — Get connection is busy or not

pg_connection_reset — Reset connection (reconnect)

pg_connection_status — Get connection status

pg_convert — Convert associative array values into suitable for SQL statement

pg_copy_from — Insert records into a table from an array

pg_copy_to — Copy a table to an array

pg_dbname — Get the database name

pg_delete — Deletes records

pg_end_copy — Sync with PostgreSQL backend

pg_escape_bytea — Escape a string for insertion into a bytea field

pg_escape_string — Escape a string for insertion into a text field

pg_execute — Sends a request to execute a prepared statement with given parameters, and waits for the result.

pg_fetch_all_columns — Fetches all rows in a particular result column as an array

pg_fetch_all — Fetches all rows from a result as an array

pg_fetch_array — Fetch a row as an array

pg_fetch_assoc — Fetch a row as an associative array

pg_fetch_object — Fetch a row as an object

pg_fetch_result — Returns values from a result resource

pg_fetch_row — Get a row as an enumerated array

pg_field_is_null — Test if a field is SQL NULL

pg_field_name — Returns the name of a field

pg_field_num — Returns the field number of the named field

pg_field_prtlen — Returns the printed length

pg_field_size — Returns the internal storage size of the named field

pg_field_table — Returns the name or oid of the tables field

pg_field_type_oid — Returns the type ID (OID) for the corresponding field number

pg_field_type — Returns the type name for the corresponding field number

pg_free_result — Free result memory

pg_get_notify — Gets SQL NOTIFY message

pg_get_pid — Gets the backend's process ID

pg_get_result — Get asynchronous query result

pg_host — Returns the host name associated with the connection

pg_insert — Insert array into table

pg_last_error — Get the last error message string of a connection

pg_last_notice — Returns the last notice message from PostgreSQL server

pg_last_oid — Returns the last row's OID

pg_lo_close — Close a large object

pg_lo_create — Create a large object

pg_lo_export — Export a large object to file

pg_lo_import — Import a large object from file

pg_lo_open — Open a large object

pg_lo_read_all — Reads an entire large object and send straight to browser

pg_lo_read — Read a large object

pg_lo_seek — Seeks position within a large object

pg_lo_tell — Returns current seek position a of large object

pg_lo_unlink — Delete a large object

pg_lo_write — Write to a large object

pg_meta_data — Get meta data for table

pg_num_fields — Returns the number of fields in a result

pg_num_rows — Returns the number of rows in a result

pg_options — Get the options associated with the connection

pg_parameter_status — Looks up a current parameter setting of the server.

pg_pconnect — Open a persistent PostgreSQL connection

pg_ping — Ping database connection

pg_port — Return the port number associated with the connection

pg_prepare — Submits a request to create a prepared statement with the given parameters, and waits for completion.

pg_put_line — Send a NULL-terminated string to PostgreSQL backend

pg_query_params — Submits a command to the server and waits for the result, with the ability to pass parameters separately from the SQL command text.

pg_query — Execute a query

pg_result_error_field — Returns an individual field of an error report.

pg_result_error — Get error message associated with result

pg_result_seek — Set internal row offset in result resource

pg_result_status — Get status of query result

pg_select — Select records

pg_send_execute — Sends a request to execute a prepared statement with given parameters, without waiting for the result(s).

pg_send_prepare — Sends a request to create a prepared statement with the given parameters, without waiting for completion.

pg_send_query_params — Submits a command and separate parameters to the server without waiting for the result(s).

pg_send_query — Sends asynchronous query

pg_set_client_encoding — Set the client encoding

pg_set_error_verbosity — Determines the verbosity of messages returned by pg_last_error and pg_result_error.

pg_trace — Enable tracing a PostgreSQL connection

pg_transaction_status — Returns the current in-transaction status of the server.

pg_tty — Return the TTY name associated with the connection

pg_unescape_bytea — Unescape binary for bytea type

pg_untrace — Disable tracing of a PostgreSQL connection

pg_update — Update table

pg_version — Returns an array with client, protocol and server version (when available)

이 글에 대한 댓글이 총 2건 있습니다.

너무 많은걸 바라시네요.

그것도 아주 우둔하게..

DB 테이블에 값을 넣기 위해선 별도로 마련된 함수가 없고 SQL 을 사용해서 DB조작을 수행해야 합니다.

사용할 함수는 pg_query 함수입니다.

쿼리문은 insert, update, delete 이며, 데이터를 가져오는 쿼리는 select 문입니다.

끝.

이상호(search5)님이 2009-02-02 14:56에 작성한 댓글입니다.

아...우둔하다는 칭찬을 들었지만!!!!
감사합니다.

souler(souler)님이 2009-02-02 15:39에 작성한 댓글입니다.

No.	제목	작성자	작성일	조회
7606	PostgreSQL 8.3.6 Released [1]	김영호	2009-02-06	7307
7604	psql 함수관련 하나만 질문드립니다 [2]	이만호	2009-02-05	7061
7603	linux서버 Db에 접속 방법에 대해서.. [1]	hwan	2009-02-05	7203
7601	이많은 함수중에.. [2]	souler	2009-02-02	9240
7600	기본 연동 예제 에러원인? [2]	souler	2009-01-30	6379
7599	포스트그레스 와 php 웹 연동하는 방법은? [1]	souler	2009-01-30	7237
7598	postgresql의 로그감시툴 [4]	초보	2009-01-29	7661

All about the DATABASE... Copyleft 1999-2024 DSN, All rights reserved.

작업시간: 0.016초, 이곳 서비스는
PostgreSQL v16.2로 자료를 관리합니다